2 variable Lookup

[andrewevandc]

I know how to use vlookup but on only 1 variable.

I have a table with two variables, part # and count, and I want to be able to
look up a 3rd variable with a formula.

Thus:

PART COUNT COST
3SA3 50 $2.23
3SA3 100 $3.99
3SA3 200 $7.89
5GX1 10 $1.80
5GX1 20 $2.99

etc. So the goal would be that if on another sheet I had the part in cell A1
and the count in Cell A2, I could use a formula in cell A3 to return the
correct cost.

Thanks,
Andrew

 

[T. Valko]

Try this:

=SUMPRODUCT(--(Sheet2!A2:A10=A1),--(Sheet2!B2:B10=A2),Sheet2!C2:C10)