| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Any way for 2 column vlookups. i.e match last name then match firs
The only complete matching information in both databases is last name and
first name. Database 2 is actually a smaller list pulling info from the larger database 1. The second database needs to pull social security info from databse 1 to put in database 2. Because of multiple last names matching I first want to match the last name in database 1 but somehow then have an "AND" statement that then requires a first name match at which point it will pullout the SS # from the row where both last and first names match. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| Need rows in Column A removed if they fully or partially match with any Column B row | Excel Discussion (Misc queries) | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| Lookup then Match and insert value from next column | Excel Worksheet Functions | |||
Threaded Mode
