Double vlookup

[Pierre]

Hello all,
My problem is quite simple for a lot of you guys :
I have 3 columns
Name, First name and age
And I want to find the age by giving the name and the first name...

Easy ??? :cool

 

[Andy B]

Hi

One way of doing this is:
=SUMPRODUCT((A2:A1000="Doe")*(B2:B1000="John")*(C2:C1000))
You could use cells to store the names and just change the formula
references to suit.