Forum Discussion
Vlookup strings - Different types of matches in Data
Hi all, I am struggling to figure out how to String Vlookup based on wildcards. Please see the image I attached to understand the problem. As you can see from the red highlighted text, I want...
A very difficult lookup because the lookup value contains more text than what you're looking for in the table array. Additionally, there's the "MS" abbreviation. I think what you're left with is using extraction formulas (LEFT, RIGHT, MID) with wildcards to do the lookup - it's very risky.