Download Excel File: https://excelisfun.net/files/EMT1691.xlsx
Learn how to perform a partial text lookup; Finding “Coca Cola” in “Coca Cola Inc.” or the reverse, find “Coca Cola Inc.” in “Coca”. See lookup formulas in Microsoft 365 Excel and any other version of Excel.
Topics:
1. (00:00) Introduction.
2. (00:10) Understand the two different Fuzzy Lookup, or Partial Text Lookup situations. Which one do you have?
3. (00:42) XLOOKUP Function Spilled Array Formula. Find “Coca Cola” in “Coca Cola Inc.” Microsoft 365 Excel. Any Version of Excel.
4. (02:52) Spilling Formulas in Microsoft 365 Excel.
5. (03:22) VLOOKUP and IFNA functions. Find “Coca Cola” in “Coca Cola Inc.”
6. (04:24) FILTER, SEARCH and ISNUMBER functions. Find “Coca Cola Inc.” in “Coca”. Microsoft 365 Excel.
7. (06:37) XLOOKUP, SEARCH and ISNUMBER functions Find “Coca Cola Inc.” in “Coca”. Microsoft 365 Excel.
8. (07:12) INDEX, MATCH, SEARCH, ISNUMBER, IF and COUNT functions. Find “Coca Cola Inc.” in “Coca”. Any Version of Excel.
9. (07:47) When you should NOT use IFERROR or IFNA.
10. (09:12) Summary, Closing and Video Links