Why don't you try parsing "Mary Smith" into "Mary" and "Smith" in adjacent
columns and then concatenate them again

A1 = Mary Smith
B1 = Mary
C1 = Smith
D1 = C1 & ", " & B1

When you are done, try the lookup again.

"Tina" wrote:

I'm running Excel 2003. I'm trying to compare two lists that don't match
exactly. I've been using Vlookup, but if the cell content of my search is
not the same as the array I'm comparing it to, it does not find it.
For example: I'm searching for "Mary Smith". The array contains "Smith,
Mary". VLookup won't find the record because it doesn't match exactly what
I'm searching for. Because I'm comparing thousands of records against an
extremely large database, it's not feasable for me to just do a search.
Any insight?

Thanks,
--
Tina