Need help setting up a formula

[gcgatordm2006]

I am trying to set up a spreadsheet for work and having a little trouble with this last formula. I first had to create a days360 to calculate the number of days between the two dates. Now what I need to do is take that number.. and set up a formula with a list of numbers. So for instance the date between today and 2/5/2012 7 months left in that contract. I have a list of numbers that depending on the months left will have a certin fee. I need to find a formula that will allow me to set this up so once it calculates the months left it will then give what the fee is for that contract. If anyone can help it would be great thanks!

 

[CWatts]

=LOOKUP(A1,{-1000,1,2,3,4,5,6,12,24},{0,5,10,15,20,25,30,100,200})

If the number is less than 1, then no fee. Once it reaches 1, it goes to $5. If it hits 6 months then its $30. If it's 8 months, the last one it was at was 6 so still $30. 14 months is $100 etc.

You can replace A1 with your other formula as well.

The above example hard codes the look up right into the formulas, but if they change frequently, you may want to just have a list on another sheet and reference that. Just let me know which you prefer.

 

[gcgatordm2006]

That totally is what I'm looking for... life saver! thanks