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,