=LOOKUP(G11,{0,39264,39630},{"PRIOR","FY08","FY09" })


"Twodot" wrote:

I am evaluating a column of dates and trying to assign each to a fiscal year.
I can't figure out what's wrong with this statement but it returns FY09 no
matter what date it is evaluating.

=IF(G11=7/1/8,"FY09",IF(G11=7/1/7,"FY08","PRIOR"))
--
twodots left