Partial Match for a Vlookup
I am looking for some help with a formula. I want to search for a particular value in a cell that may include multiple values i.e I want to locate A123 but the cell from the reference sheet contains A123; B456.
My thought was to use a partial vlookup but from what I have read it does not look like wildcards can be used and I haven't been able to leverage the contains function either.
Would anyone have any suggestions?
Help Article Resources
Check out the Formula Handbook template!