Hi,
In the enclosed sheet am trying to use the formula to search a number of entries that contain data and return a value if a partial match is found from a reference data set with a specific value. I have seen others use wildcards to search inside a string, but it does not seem to work for me. Perhaps a better way to do it?
=VLOOKUP("*"&A2&"*",$A$9:$B$13,2,FALSE)
If I just use the data I am looking for it works fine, just not along with other text.
Notes -
The notation I am searching for will always be at the end of the string surrounded by (). Not sure if that makes is better or worse....
Thanks in advance for any/all help.
Bookmarks