| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text string comparison - closest match
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 joined First and Lastnames in both the worksheets, used VLOOKUP and got the userid in WS2, if the names matches exactly (not shown here). But if the names doesn't match exactly, as above, VLOOKUP doesn't work. Eventhough we can see the names are there, but either contain additional/less initials, reversed first and last name etc. Is there any other way I can get the result? -- pappu ------------------------------------------------------------------------ pappu's Profile: http://www.excelforum.com/member.php...o&userid=36041 View this thread: http://www.excelforum.com/showthread...hreadid=558343 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text string comparison - closest match
See response (a formulas play) in your later post
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "pappu" wrote: 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 joined First and Lastnames in both the worksheets, used VLOOKUP and got the userid in WS2, if the names matches exactly (not shown here). But if the names doesn't match exactly, as above, VLOOKUP doesn't work. Eventhough we can see the names are there, but either contain additional/less initials, reversed first and last name etc. Is there any other way I can get the result? -- pappu ------------------------------------------------------------------------ pappu's Profile: http://www.excelforum.com/member.php...o&userid=36041 View this thread: http://www.excelforum.com/showthread...hreadid=558343 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding a text string w/in a Cell | Excel Discussion (Misc queries) | |||
| 25 days previous to today? | Excel Discussion (Misc queries) | |||
| Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
| Extracting integers from a text string. | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Linear Mode
