How do I lookup multilple criteria and return a single value

[Guest]

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

 

[Peo Sjoblom]

=INDEX(C2:C200,MATCH(1,(A2:A200=first_name)*(B2:B200="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