Text string comparison - closest match

  • Thread starter Thread starter pappu
  • Start date Start date
P

pappu

I have data in 2 worksheets, say WS1, WS2

WS1 contains following plus other data
--------------------------------------
FirstName LastName UserID
--------------------------------------
Serine S H Koay WKOAS
Roger Groebi WGROR
Jill Neubronner WNEUJ
Su Ann Low WLOWV
--------------------------------------

WS2 contains following plus other data
--------------------------------------
FirstName LastName UserID
--------------------------------------
Serine Koay
Roger A Groebi
Neubronner Jill
Su Ann Low
--------------------------------------

I need to find userID in WS2 for corresponding names from WS1. I joine
First and Lastnames in both the worksheets, used VLOOKUP and got th
userid in WS2, if the names matches exactly (not shown here). But i
the names doesn't match exactly, as above, VLOOKUP doesn't work
Eventhough we can see the names are there, but either contai
additional/less initials, reversed first and last name etc.

Is there any other way I can get the result
 
Back
Top