Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to match one name record downloaded from a database to another
name record downloaded from our information system. The two name lists are not in the same format, so an identical search will not work. The downloaded database list may or may not have middle initial or middle name and also contains business names, so parsing the information out into last name and first name to concatenate for the match is also not feasible. Can anyone think of a way to use the wildcard search to determine if a match is identified between the two lists? Any and all help would be greatly appreciated! Thanks, in advance! Tammy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup looks to the prior column if zero appears in the lookup col | Excel Discussion (Misc queries) | |||
Matrix lookup/mulitple criteria lookup | Excel Discussion (Misc queries) | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) |