How do I lookup multilple criteria and return a single value

[StephenAccountant]

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


"StephenAccountant" <StephenAccountant@discussions.microsoft.com> wrote in
message news:1594CA07-5181-4EAC-A663-70CA9CC8C3FD@microsoft.com...
> 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??