| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested Formula?
I am trying to create a formula and I am stuck.
For example: If cell A1 is 240 then use the rates from the Rates! sheet cells A1!:B11!, If cell A1 is 600 then use the rates from the Rates! sheet cells C1!:D11! All of this depends on what is in cell A2 The formula I used was: IF$A1=240,IF($A20,VLOOKUP($G9,Rates!$A$1:$B$11,2) ),$A1=600,if($A20,vlookup($G9,rates!$C$1:$D$11,0) )) Is it possible to write a formula like this? I just keep getting error messages. Any suggestions would be greatly appreciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible? | Excel Worksheet Functions | |||
| Problem with nested IF and OR formula? | Excel Discussion (Misc queries) | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Excel nested IF formula question | Excel Discussion (Misc queries) | |||
Threaded Mode
