| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement propblem
I have the below formula which is referencing a Data Valadation list (D5).
Does anyone have any ideas to expand it to inlcude all 12 months? =IF($D$5="APR07",APR07!F$6,IF($D$5="MAY07",MAY07!F $6,IF($D$5="JUN07",JUN07!F$6,""))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| If Statement help (I think) | Excel Discussion (Misc queries) | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Threaded Mode
