MATCH

D

d_campelo

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,
 
T

Teethless mama

C2: Holds criteria

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

Adjust to suit
 
Top