I think you have missed an IF from the middle, and your second VLOOKUP
is missing a column_ref. As the A20 condition applies to both, you
might like to try this variation:

=IF($A20,IF($A1=240,VLOOKUP($G9,Rates!$A$1:$B$11, 2,0),IF($A1=600,VLOOKUP($G9,Rates!$C$1:$D$11,2,0), 0)),0)

I have assumed you want a result of 0 if A2 is not greater than 0 (last
parameter).

Hope this helps.

Pete

cwilliams wrote:
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