Vlookup with 2 criteria

[Notters]

Hi,

Im trying to do a Vlookup using 2 lookup criteria. I assume this is some kind of SUMPRODUCT formula but i can not get it to work.

Please see the attached example. I need to populate in G4 the number of cars Tim has ordered based on the information in the table in Cols A to C.

I need to then copy it down to get the other order quatities per product. and across to hets Jaynes details.

many thanks

[dilipandey]

Hi Notters,

Use the following formula in G4 and copy it down :-

=SUMPRODUCT(($A$4:$A$45=$F$3)*($B$4:$B$45=$F4),$C$4:$C$45)

Apply the same formula for jayne as well.

Regards,
DILIPandey
< Click on below star if this helps >

[Fotis1991]

Hi Notters

In g13, put the formula:

=INDEX($C$4:$C$45;MATCH(1;($F$12=$A$4:$A$45)*(F13=$B$4:$B$45);0))

cfe formula

Hope to helps you.

[Notters]

Thanks Guys, this is great.

[dilipandey]

You are welcome Notters.

Cheers


Regards,
DILIPandey

[jpr73]

Hi,
Another solution with pivot table
Basic data in a table and pivot table with multiple filter
Best regards