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

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

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

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

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