Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Simple problem - hard to figure. (This report is imported with information
missing - it only contains a first initial instead of the name - AND the initial could be wrong - so I consider the column empty) Column A has last name, Column B has first initial, Column F has birthdate. I am trying to match the Last Name (Column A) and Birthdate (Column F) to give me the First name......(Column B) I created a 'lookup file" on sheet 2 showing last names AND first names and Birthdate. I know that VLookup with give me last name and show the First name... but there are hundreds of names. I need to Match 2 criterial - the last name with the Birthdate to give me the first name. Would really appreciate help. Working on this for tomorrow at work. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
lookup with uneven columns | Excel Worksheet Functions | |||
Lookup in Two Columns, Help needed with formula | Excel Worksheet Functions | |||
Populating a field based on lookup values | Excel Worksheet Functions | |||
Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions | |||
Lookup function skipping columns | Excel Worksheet Functions |