Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Nested IF | Excel Worksheet Functions | |||
nested if | Excel Discussion (Misc queries) | |||
Nested IFs | Excel Worksheet Functions | |||
nested if based on nested if in seperate sheet. how? | Excel Worksheet Functions | |||
Nested IF | Excel Worksheet Functions |