Hello,
Apologies if the title is not very clear, I will try to explain what I am trying to do (unsuccessfully after a few attempts and googling).
I would like to perform a VLOOKUP or similar on data that is organised like this:
A B C D E 1 Data of interest Source array Source array 2 text2 text1, text2, text3 value1
Importantly, the text in D2 is all present in the same cell. I would basically like to get "value1" in B2, corresponding to a match with the content of B1. If the list in D2 was not separated by commas, I would do a simple VLOOKUP and get it, but I don't know how to extract "text2" from the cell to perform the VLOOKUP. I've tried combinations of VLOOKUP and MATCH but I can't seem to figure it out.
Many thanks for your help and your time on this basic question!
G.
Bookmarks