Hi,

Try this

=if(indirect(A2&"!L$3")=0,"",indirect(A2&"!L$3"))

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Yrrep" wrote in message
...
I want to copy the formula below down the sheet so that the week
increases. i.e. week 12 week 13 etc. (The week represents a different
named sheet)

=IF(Week12!L$3=0,"",Week12!L$3)