If statement propblem

[Guest]

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

 

[Jim Rech]

=INDIRECT(D5&"!F6")

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

 

[Arvi Laanemets]

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

 

[Guest]

Thank you the choose and match formula worked great. I could not get the
INDIRECT one to work though.

 

[Jim Rech]

Perhaps you missed the apostrophe.

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