Nested Functions
 

Try ...

=INDIRECT("'Stats and Forecasts - 351'!" & VLOOKUP('Report
Parameters'!E5,Sheet2!A1:B12,2,0))

where sheet2, columns A & B contain month and corresponding cell address

January B48
February E48
etc

HTH

"Bryan Potter" wrote:

Is there any way to bypass the limit of 7 nested functions?

The following formula should return the value in 1 of 12 columns based on
the month that is selected from a drop down menu. However, the limitation of
7 nested functions does not allow it to work? Any ideas how go about this a
different way?

=IF('Report Parameters'!$E$5 = "January", 'Stats and Forecasts - 351'!B48,
IF('Report Parameters'!$E$5 = "February", 'Stats and Forecasts - 351'!E48,
IF('Report Parameters'!$E$5 = "March", 'Stats and Forecasts - 351'!H48,
IF('Report Parameters'!$E$5 = "April", 'Stats and Forecasts - 351'!K48,
IF('Report Parameters'!$E$5 = "May", 'Stats and Forecasts - 351'!N48,
IF('Report Parameters'!$E$5 = "June", 'Stats and Forecasts - 351'!Q48,
IF('Report Parameters'!$E$5 = "July", 'Stats and Forecasts - 351'!T48,
IF('Report Parameters'!$E$5 = "August", 'Stats and Forecasts - 351'!W48),
IF('Report Parameters'!$E$5 = "September", 'Stats and Forecasts - 351'!Z48,
IF('Report Parameters'!$E$5 = "October", 'Stats and Forecasts - 351'!AC48,
IF('Report Parameters'!$E$5 = "November", 'Stats and Forecasts - 351'!AF48,
IF('Report Parameters'!$E$5 = "December", 'Stats and Forecasts -
351'!AI48)))))))))))

Thanks,

Bryan