Excel doesn't do fuzzy logic very well.

Could you use a wildcard or two?

=VLOOKUP("jo*n*",A1:B10,2,FALSE)

Will find johnson, johnston, johnstone, jones, jobergen


Gord Dibben MS Excel MVP

On Thu, 1 May 2008 16:00:24 -0700, dk wrote:

Can we make a vlookup when lastname may have slightly differnt spelling in
middle characters?