Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 variable Lookup
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable lookup | Excel Worksheet Functions | |||
Lookup using variable name | Excel Worksheet Functions | |||
Lookup on more than one variable in 2003 | Excel Discussion (Misc queries) | |||
3 variable lookup | Excel Worksheet Functions | |||
Variable Lookup/Double Lookup | Excel Worksheet Functions |