Forum Discussion
Need Function for cross validating data lists with partial cell contents.
Since you're using a single column in the VLOOKUP table array, I'm guessing you're more interested in if the lookup value is present anywhere in H.
Try this:
=MATCH("*"&B6&"*",Tab!H:H,0)
Be careful with partial matches if you're looking up a value that's very short or a term that's common.
Patrick2788 You don't know it MATCH has any weird limitations do you? I noticed that it brings false negatives for particularly densely populated cells.
MATCH is like most lookups in that it is number/text sensitive.
e.g. 100 does not equal "100"
100=100
"100"="100"
Patrick2788 I thought that might be the case, but I can't see a format difference. It just doesn't like some of the larger cells. I even took the offending contents, put them in Notepad, then pasted them back again. Just puzzling.