Uploaded November 2017 | Updated September 2026, 8 minutes ago

---

00:00 Bill Szysz solution (no search function!)
00:37 Step 1 Hack the match function
01:42 Step 2 Look for a 1 inside of Step 1
02:28 Step 3 Index gives us the answer
03:10 Compare solutions (Deb Kevin Ankur Bill)
Here's my blog post comparing various solutions! myspreadsheetlab.com/look-for-keywords-inside-of-a-column-of-text-values