| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup command
Hi ...
I have this formula, which works fine.... =IF(I1<50000,LOOKUP(I1,{30000,40000},{"0.002","0.0 03"}),IF(I1<100000,LOOKUP(I1,{80000,90000},{"0.002 ","0.003"}))) suppose I would like to replace 30000,40000,80000 and 90000 with actual cell references, i.e. in Cell A1 = 30000, thus allowing the lookup value to be dynamic. Any ideas? Thanks, PJS |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| command code ( GOTO command) in formula | New Users to Excel | |||
| Referencing a Rounded number in a LOOKUP command | Excel Discussion (Misc queries) | |||
| Pivot Table Error Message - "Command Text not set for command obje | Excel Discussion (Misc queries) | |||
| LOOKUP Command Issue | Excel Worksheet Functions | |||
| LOOKUP command | Excel Worksheet Functions | |||
Threaded Mode
