On Thu, 29 Dec 2005 10:31:02 -0800, "Struggling of Essex"
wrote:

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?

Set up a table some place:

2006 $800k
2007 $1200k
2008 $2000k
2009 $2500k
2010 $3000k


Use this formula:

=VLOOKUP(YEAR(Start_Date),Table,2)

Start_date refers to a cell containing your start date as a normal excel date.

Table refers to the range where the above table is located.
--ron