Nested If
 

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,

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,

Nested If
 

Try the below formula

=INDIRECT(A3 & "!B9")

If this post helps click Yes
---------------
Jacob Skaria


"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,