Double vlookup

P

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: :cool
 
A

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.
 
Top