I think there is still one part missing from the formula....the J10 cell

=IF($J9=240,VLOOKUP($G9,Rates!$A$3:$B$11,2,0),IF($ J9=600,VLOOKUP($G9,Rates!$D$3:$E$11,2,0),"Decline" ))

Based on the info in J10 (the numbers 0,1,2,3,or 4) will determine what rate
to use on the Rate! sheet. That was why in my original formula I had
IF$A1=240,IF($A20
meaning if it was more then 0 then use use the rates from the rage a3;b11 on
Rates! spreadsheet

Rates spreadsheet looks like this

1 $244.40
30 $321.84
40 $385.30
45 $434.98
50 $519.24
55 $620.80
60 $779.67
65 $856.39
70 $943.51
2 $410.33
3 $367.73
4 $612.87

Does this make sense?

"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