| 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,""))) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If statement propblem
=INDIRECT(D5&"!F6")
-- Jim "Scott@CW" wrote in message ... |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,""))) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If statement propblem
Hi
=CHOOSE(MATCH($D$5,{"JAN07","FEB07","MAR07","APR07 ","MAY07","JUN07","JUL07","AUG07","SEP07","OKT07", "NOV07","DEC07"},0),JAN07!F$6;FEB07!F$6;MAR07!F$6; APR07!F$6;MAY07!F$6;JUN07!F$6;JUL07!F$6;AUG07!F$6; SEP07!F$6;OKT07!F$6;NOV07!F$6;DEC07!F$6) Or =INDIRECT($D$5 & "!F6") Arvi Laanemets "Scott@CW" wrote in message ... 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,""))) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If statement propblem
Thank you the choose and match formula worked great. I could not get the
INDIRECT one to work though. "Arvi Laanemets" wrote: Hi =CHOOSE(MATCH($D$5,{"JAN07","FEB07","MAR07","APR07 ","MAY07","JUN07","JUL07","AUG07","SEP07","OKT07", "NOV07","DEC07"},0),JAN07!F$6;FEB07!F$6;MAR07!F$6; APR07!F$6;MAY07!F$6;JUN07!F$6;JUL07!F$6;AUG07!F$6; SEP07!F$6;OKT07!F$6;NOV07!F$6;DEC07!F$6) Or =INDIRECT($D$5 & "!F6") Arvi Laanemets "Scott@CW" wrote in message ... 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,""))) |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If statement propblem
Perhaps you missed the apostrophe.
-- Jim "Scott@CW" wrote in message ... | Thank you the choose and match formula worked great. I could not get the | INDIRECT one to work though. | | "Arvi Laanemets" wrote: | | Hi | | | =CHOOSE(MATCH($D$5,{"JAN07","FEB07","MAR07","APR07 ","MAY07","JUN07","JUL07","AUG07","SEP07","OKT07", "NOV07","DEC07"},0),JAN07!F$6;FEB07!F$6;MAR07!F$6; APR07!F$6;MAY07!F$6;JUN07!F$6;JUL07!F$6;AUG07!F$6; SEP07!F$6;OKT07!F$6;NOV07!F$6;DEC07!F$6) | | Or | =INDIRECT($D$5 & "!F6") | | | Arvi Laanemets | | | | | "Scott@CW" wrote in message | ... | 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,""))) | | | |
| Reply |
| 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 | |||
Linear Mode
