| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
two sets of variables to find result
I can't seem to find the right formula for this formula.
A2:A100 = product code B2:B100 = price (level 3) C2:C100 = price (level 2) D2:D100 = price (level 1) If I enter a product code in cell E1 and enter "Level 3" in cell F1, I want the formula in cell G1 to tell me what the price of that product is in the column B for that level. I hope this makes sense and someone can help me as I know I have used this before. Thanks! Annette |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
two sets of variables to find result
You could try something like:
=VLOOKUP(E1,A2:D100,LOOKUP(F1,{"Level 1","Level 2","Level 3"},{4,3,2}),FALSE) HTH Elkar "Annette" wrote: I can't seem to find the right formula for this formula. A2:A100 = product code B2:B100 = price (level 3) C2:C100 = price (level 2) D2:D100 = price (level 1) If I enter a product code in cell E1 and enter "Level 3" in cell F1, I want the formula in cell G1 to tell me what the price of that product is in the column B for that level. I hope this makes sense and someone can help me as I know I have used this before. Thanks! Annette |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
two sets of variables to find result
Perfect ... thanks much!
"Elkar" wrote in message ... You could try something like: =VLOOKUP(E1,A2:D100,LOOKUP(F1,{"Level 1","Level 2","Level 3"},{4,3,2}),FALSE) HTH Elkar "Annette" wrote: I can't seem to find the right formula for this formula. A2:A100 = product code B2:B100 = price (level 3) C2:C100 = price (level 2) D2:D100 = price (level 1) If I enter a product code in cell E1 and enter "Level 3" in cell F1, I want the formula in cell G1 to tell me what the price of that product is in the column B for that level. I hope this makes sense and someone can help me as I know I have used this before. Thanks! Annette |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
two sets of variables to find result
=INDEX(B2:D100,MATCH(E1,A2:A100,0),MATCH(F1,{"Leve l 1","Level 2","Level
3"},0)) -- __________________________________ HTH Bob "Annette" wrote in message ... I can't seem to find the right formula for this formula. A2:A100 = product code B2:B100 = price (level 3) C2:C100 = price (level 2) D2:D100 = price (level 1) If I enter a product code in cell E1 and enter "Level 3" in cell F1, I want the formula in cell G1 to tell me what the price of that product is in the column B for that level. I hope this makes sense and someone can help me as I know I have used this before. Thanks! Annette |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to get a result from 2 variables | Excel Worksheet Functions | |||
| two variables to get result | Excel Worksheet Functions | |||
| I need to create an Excel chart with 5 sets of variables | Charts and Charting in Excel | |||
| TWO VARIABLES - ONE RESULT | Excel Discussion (Misc queries) | |||
| How do I sort variables into sets of three? | Excel Discussion (Misc queries) | |||
![Annette[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
