C2: Holds criteria

=INDEX(A2:A100,MATCH("*"&C2&"*",B2:B100,FALSE))

Adjust to suit


" wrote:

I'm using INDEX(...,MATCH(..,...,...,FALSE)) to match two columns with names.
The names in the columns are not identical but I still would like to match
them, even if there is an extra space, coma, or one is capitalized and the
other isn't.

Any suggestions?


thanks,