can you use wildcards with vlookup?

Viewed 47172

i would like to do a vlookup, but i would like it to match the SUBSET of a cell. is this possible?

for example, if i am looking for "alex is smart" and the cell has "alex is smart blah blah", i want it to match on alex is smart

is this possible?

1 Answers
Related