Hello
On sheet 1 column A I have the below text
Apples are great
Best grapes ever
Give me a strawberry
On Sheet 2 column A I have
Apple
Grape
Strawberry
Column B has a number value for each one
1
2
3
How do I use VLookup (along with any other functions) to search for the specific word in each phrase (of sheet 1 column a) and return the number value on column B sheet 1 for the word that it finds.
Hello!
Try this:
Please Login or Register to view this content.
If I have solved your question, please mark the thread as [SOLVED],
And consider adding reputation
?Simplicity is the ultimate sophistication? (Leonardo Da Vinci)
Regards,
F?bio Gatti
https://www.youtube.com/pulodogatti
https://www.linkedin.com/in/fabiocgatti/
https://instagram.com/pulodogatti
Like this...
Data Range
This formula entered in B1 and copied down:
=IFERROR(LOOKUP(1E100,SEARCH(E$1:E$3,A1),F$1:F$3),"")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks