S
Scott@CW
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,"")))
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,"")))