Uploaded October 2017 | Updated September 2026, 2 hours ago

---

Visit Deb's amazing websites:
debradalgleish.com
youtube.com/user/contextures
DEB's ARRAY FORMULA SOLUTION
00:00 Formula puzzle explanation
01:19 Step 1 Look for each 'Customer'
02:33 Step 2 Replace errors with zero
02:58 Step 3 Look for a 1 inside the array
04:48 Step 4 Index gets the 'Code' answer
05:38 My alternative array solution
...I've learned SO much from Deb over the years. Thanks and Happy Spreadsheet Day!
Here's my blog post comparing various solutions! myspreadsheetlab.com/look-for-keywords-inside-of-a-column-of-text-values