Forum Discussion
Solved
How to use VLOOKUP to return a textstring based on a value as a part of a textstring in another cell
Hey, sorry if the title is unclear, but what I'm looking for actually seems pretty simple (to me, at least). I've attached a screenshot of my workbook below. Essentially, I have the title of the ...
NikolinoDE Hey, I've attached a sample of the workbook below. I just want B2 to take the keywords in Column C, look for them in A2, and then populate B2 based on the matching value in Column D. (So if A2 says "headlight" I want B2 to autofill with "automotive-headlight-assemblies", because that's what I have matching up in the table C:D.
Detlef_Lewin That worked!!!! Thank you so much!!!
Additional question - how the heck did you even know that? Did you just know the right formula off-hand, or do you have a good way of looking it up?