Hi Everyone,

I need help with this formula. Can't seem to figure out what I'm doing wrong:

=IF((F1="1 April 2008"),'[Dummy Forecast AprMayJun
2008.xls]Sheet1'!$E$22,IF((F1="1 May 2008"),'[Dummy Forecast AprMayJun
2008.xls]Sheet1'!$F$22,IF((F1="1 June 2008"),'[Dummy Forecast AprMayJun
2008.xls]Sheet1'!$G$22,"")))

Basically, what I want the formula to do is to check cell F1 to see what
date is entered and to then return the value contained in the appropriate
cell in Sheet1 of the Dummy Forecast AprMayJun 2008 workbook.

At present the formula returns a blank value regardless of what F1 contains
in it, but it should be returning either $35,500 , $0, or $119,000.

What am I doing wrong? And once this is fixed, can I extend the formula so
that I can cater for all twelve months, or is that stretching the nesting
capability too far?

Thanks.







--
If you can measure it, you can improve it!