Uploaded November 2017 | Updated September 2026, 2 hours ago

---

00:00 Ankur's Lookup & Search solution
00:39 Review of requirements
02:23 Deb's solution
03:04 Step 1 search array
03:55 Step 2 1 divided by search array results
05:10 Step 3 search for a 2 (we'll never find)
05:35 *key concept* Binning
09:10 Step 4 [result_vector] displays answer
Original idea came from Deb's Spreadsheet day challenge
Visit Deb's website and youtube:
debradalgleish.com
youtube.com/user/contextures
Here's my blog post comparing various solutions! myspreadsheetlab.com/look-for-keywords-inside-of-a-column-of-text-values