Forum Discussion
Find word from list (string) - without macros
Hi everbody, I am trying to find specific words from a list of items. I want to know if the word is in the strings given, and if it is, bring to cell C the classification of each item. I want ...
Let's say the second list is in A2:B10 on Sheet 2 (with headers in A1:B1).
In C2 on the first sheet:
=LOOKUP(1000,SEARCH('Sheet 2'!$A$2:$A$10,B2),'Sheet 2'!$B$2:$B$10)
Fill down.
See the attached demo.
Thank you, HansVogelaar
Exactly what I needed!
I tried also with VLOOKUP + wildcards and was just about to start checking the Fuzzy LookUp but this does the job perfectly!
Thanks!!!