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
|