I have two worsheets with one workbook and I am trying to match the names and
return certain fields associated with these names. I was wondering if you
could use the like feature such as the one in Access that matches on so many
characters of the field (because my names don't match exactly in order for me
to use a vlookup). For example:

Column A Column B Column C
John B Smith, MD 1254654 56892
Smith John B M.D 1254654 52869

How would I do a match on these names (Column A) and possibly return the
correct information