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.
Hi HansVogelaar
May I ask what does the "1000" do in that case?
Sometimes is working, sometimes is not...Plus, I need something with a higher limit, does something else come to your mind?
Thanks!1000 is an arbitrary large number. You can change it to 1000000 or 1000000000 if 1000 is not large enough.
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!!!
