Hi All,
I'm struggling with trying to do a VLOOKUP with a partial value and looking for some guidance. As you can see in the attached Tab-1 I have a list of values. The data highlighted in red is what I am interested in, the rest of the information is redundant and in my real file spans over 10000 lines.
On Tab-2 I have a cleansed data list with an associated value. These values match the text in red on Tab-1. I therefore want to try and lookup the partial value from each cell in Tab-1 and pick up the info from tab 2.
I had tried the standard partial VLOOKUP("*"&A2&"*") but this won't work because the additional information is actually on Tab-1 and not Tab-2. I can't do the VLOOKUP on Tab-2 because there is multiple versions of the data in red with different suffix and prefix's.
Also key to note throughout this dataset the suffix and prefix could be different lengths as could the data I need in Red.
I have tried lots of different formulas including VLOOKUP, INDEX MATCH etc etc but I think the dataset could need cleansed before I proceed.
Any ideas?
Thanks
Bookmarks