Nested If
Try
=INDIRECT(A3&"!B9")
Mike
"SeanF74" wrote:
I need to use 11 if statements in a nested if, but Excel 2003 only allows 6
or 7. Here is what I am trying to do:
In Cell A3 on Sheet1, users can select the months from a dropdown menu. The
result I desire is that the lower table updates based on the month input by
referencing other sheets. Here is what I am trying to do:
=if(A3="January", 'January'!B9, if(A3="February", 'February!'B9,
if(A3="March", 'March'!B9, if(A3="April", 'April!'B9, if(A3="May", 'May'!B9,
if(A3="June", 'June'!B9,...if(A3="November", 'November'!B9,
'December'!B9)))))))))))
The data from each month needs to be on different sheets for easy of
reading. Is there any way to do something with a similar outcome in Excel
2003?
Thanks,
|