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?