Hi

Is it possible to look up a value to apply in a formula based on a date
entered in a spreadsheet.

For example I enter a date in a cell A2 of 06/05/2006 I want this to be
used as a lookup of factors that are to be applied for each financial
year. In the case above this would be 2006 and a factor of 1.5

I have factors for 5 years from 2006 -2011 stored in another range of
spreadsheet.

Obviously I can do this with a lookup by entering every date and
allocating the appropriate factor - but is there a cleaner way of doing
this.

Thanks for any input :)


--
IanEmery
------------------------------------------------------------------------
IanEmery's Profile: http://www.excelforum.com/member.php...o&userid=35714
View this thread: http://www.excelforum.com/showthread...hreadid=562374