Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP and MATCH w/ name search?
I have a worksheet with info from 2 databases. I'm trying to match names in different columns that have different formats. One has LN, FN, Initial format with info presented in 1 column (Column B), the other has LN,FN with info in 2columns, H:I, all names sorted alpha ascending. Due to the queries involved (PeopleSoft & Employease DB's), I do not have a matching determinate like SSN. I poked around using MS Help - that was an exercise in frustration, and even tried to cobble together a funtion using VLOOKUP and MATCH (or LEN) was futile. The shortest employee name is 4 characters. Can you give me an example I can use for this problem? Any help is sincerely appreciated. Thanks. Mark Boston -- LTUser54 ------------------------------------------------------------------------ LTUser54's Profile: http://www.excelforum.com/member.php...o&userid=33459 View this thread: http://www.excelforum.com/showthread...hreadid=544325 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP and MATCH w/ name search?
You can check this page:
http://www.contextures.com/xlFunctions03.html The example 4 of INDEX and MATCH can be useful in your case. Hope this helps, Miguel. "LTUser54" wrote: I have a worksheet with info from 2 databases. I'm trying to match names in different columns that have different formats. One has LN, FN, Initial format with info presented in 1 column (Column B), the other has LN,FN with info in 2columns, H:I, all names sorted alpha ascending. Due to the queries involved (PeopleSoft & Employease DB's), I do not have a matching determinate like SSN. I poked around using MS Help - that was an exercise in frustration, and even tried to cobble together a funtion using VLOOKUP and MATCH (or LEN) was futile. The shortest employee name is 4 characters. Can you give me an example I can use for this problem? Any help is sincerely appreciated. Thanks. Mark Boston -- LTUser54 ------------------------------------------------------------------------ LTUser54's Profile: http://www.excelforum.com/member.php...o&userid=33459 View this thread: http://www.excelforum.com/showthread...hreadid=544325 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Partial String Match Using VLOOKUP | Excel Worksheet Functions | |||
Tricky ... Pullout related rows that match a single word using Vlookup | Excel Discussion (Misc queries) | |||
Using Search with either vlookup or match and index | Excel Worksheet Functions | |||
is there a way to search with vlookup to match more than 1 column | Excel Discussion (Misc queries) | |||
Vlookup, Index & Match | Excel Worksheet Functions |