Hi,
I need to perform a search within text to find out what word is included (from a list of words within range) and then vlookup/offset this result.
For example: I need to find text within column "B" that matches any row from column "E" and write corresponding class from column "F".
Specifically, it finds word salmon in B3 that matches a result from range in column "E" then it matches Salmon with Fish and shows it as a result - I need to know what word or row it matches so I can vlookup or offset this to get Fish from column "F".
Example.JPG
I am able to say whether any word from column "E" is present but I can't say what word it is :/
Thank a lot for your ideas.
Lukas
Bookmarks