Hi

Is it possible to compare two lists of names (for example) and return the
closest match from the second list for comparison?

Basically I was trying to do a VLOOKUP based on a list of names and a second
sheet with names and data but as these were input separately there may be
spelling differences or typos in the names. If I could include in the values
returned the name from the second list which was closest to my LOOKUP_VALUE,
by comparing the two names I would be able to make a decision as too whether
there was a typo or that a close enough match did not exist.

I'm currently using Office 2003.

Thanks for any input.