Hello Ian,

take
=VLOOKUP(YEAR(A1)-(A1<DATE(YEAR(A1),4,1)),$C$1:$D$6,2,FALSE)

C1:D6:
2006 1.5
2007 2
2008 2.5
2009 3
2010 3.5
2011 4

Fiscal year 2006 is 1-Apr-2006 until 31-Mar-2007 here, right?

HTH,
Bernd