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