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??

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??