| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I lookup multilple criteria and return a single value
Hi,
I have two lists. One is a comprehensive list and the other is a simple list. I am trying to import data from the simple list into the comprehensive list. Comprehensive List A B C D 1 First Name Second Name Address Code 2 John Doe 123 blah blah 3 Peter Smith 456 blah blah etc Now in this list the cells under the code column are all blank but all others have values Simple List A B C 1 First Name Surname Code 2 Ben Dover 1234 3 Amanda Huginkiss 5678 etc etc I need to look up the first name and the surname in the simple list and return the code value into the comprehensive list. Vlookup will lookup one cell reference. Thoughts?? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I lookup multilple criteria and return a single value
=INDEX(C2:C200,MATCH(1,(A2:A200=first_name)*(B2:B2 00="last_name),0))
entered with ctrl + shift & enter -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "StephenAccountant" wrote in message ... Hi, I have two lists. One is a comprehensive list and the other is a simple list. I am trying to import data from the simple list into the comprehensive list. Comprehensive List A B C D 1 First Name Second Name Address Code 2 John Doe 123 blah blah 3 Peter Smith 456 blah blah etc Now in this list the cells under the code column are all blank but all others have values Simple List A B C 1 First Name Surname Code 2 Ben Dover 1234 3 Amanda Huginkiss 5678 etc etc I need to look up the first name and the surname in the simple list and return the code value into the comprehensive list. Vlookup will lookup one cell reference. Thoughts?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return multiple rows of data based on criteria | Excel Worksheet Functions | |||
| Lookup Multiple Criteria return One answer | Excel Worksheet Functions | |||
| Match Single Numeric Criteria and Return Multiple Numeric Labels | Excel Worksheet Functions | |||
| Match Single Numeric Criteria and Return Multiple Numeric Labels | Excel Worksheet Functions | |||
| Lookup: 2 criteria | Excel Discussion (Misc queries) | |||
Hybrid Mode
