Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to use a lookup function in an if formula.
Creating a cost estimate sheet. I have five parameters and each one has 16
parameters. I can use lookup =LOOKUP(A3,{1,4,5,6,7,8,10,12,14,16,18,20,22,24,30 ,36},{1.08,1.23,1.45,1.62,2,2.46,2.85,4.24,4.7,5.2 5,5.8,6.3,9.55,11.45"}) for one but this formula has five versions each with different pricing. therefore I am trying to make an if formula something like =IF(A2=1,"=LOOKUP(A3,{1,4,5,6,7,8,10,12,14,16,18,2 0,22,24,30,36},{1.08,1.23,1.45,1.62,2,2.46,2.85,4. 24,4.7,5.25,5.8,6.3,9.55,11.45})",IF(A2=2,"B", IF(A2=3,"C",IF(A2=4,"D","F")))) Problem though is it takes the answer as text and not another formula ideas solutions or am overloading the program. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Formula Using LOOKUP function. | Excel Worksheet Functions | |||
how to combine an IF Function with a lookup function to determine | Excel Worksheet Functions | |||
Lookup function | Excel Worksheet Functions | |||
lookup function | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) |