Here are some ideas:
a) =CHOOSE(A10-2000,1200,1500,1600........)
b)=IF(A11=2006,2000,IF(A11=2007,2000,IF(A11=2008,2 500,0)))
come back with specific question
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Struggling of Essex" wrote in
message ...
I am producing a cashflow. It is over five years, I have established that
average contract values for 2006, 2007, 2008 2009 and 2010 will be 800k,
1200k, 2000k, 2500k and 3000k respectively. I want the cell with the
contract
value to change automatically if a project start date is entered, eg if a
project starts in March 2007 its value will be 1200k.

Can anyone help me?