| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Confused with IF and LOOKUP function
I have a list which contains a full list of names and corresponding ID numbers:
A1: ID# B1: SURNAME C1: FIRST_NAME D1: DOB I have another worksheet where I have a subset of the names and need to populate the ID# if the SURNAME, FIRST_NAME and DOB match. A1: currently blank but need to populate ID# B1: SURNAME C1: FIRST_NAME D1: DOB Can anyone help? Thanks Chris |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Confused on a function | Excel Worksheet Functions | |||
| :S confused :S | Excel Discussion (Misc queries) | |||
| :S confused :S | Charts and Charting in Excel | |||
| Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
| confused by COLUMN worksheet function | Excel Discussion (Misc queries) | |||
Threaded Mode
