2 variable Lookup
Try this:
=SUMPRODUCT(--(Sheet2!A2:A10=A1),--(Sheet2!B2:B10=A2),Sheet2!C2:C10)
--
Biff
Microsoft Excel MVP
"andrewevandc" <u51945@uwe wrote in message news:9621c354daf15@uwe...
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
|