Excel - find matching text from array and lookup value
Posted on 2013-10-29
Experts, I have a column in excel that contains product descriptions (e.g. Col A)
Some of the descriptions contain specific product attributes that would be useful to have in a separate column. If so, then I would like to extract them and enter them into an adjacent column e.g. Col B).
For simple matches against one or two values I have been using something like this:
That works great for one or two column values. Now however, I need to perform the same "contains" type of search and then match against a larger list of values so that if the product description in ColA contains any of the following, then insert the matching word in Col B.
Way too many for nested if formulas.
However, I can't figure out the right combination of other functions to use to solve this by first seeing if any one of the values exists within the text in ColA and if so, entering the one that matches into ColB.
Lookup, Vlookup, Index/Match or ??
Thanks in advance!