Hi Mike,

do the following:

=INDIRECT(A1&"!B2")

Here I enter Jan in cell A1 in the scores sheet. So the function will
look at cell A1 and read the month from this cell and pick up the value
from cell B2 in the concerned sheet.

Your case would be:

=IF(INDIRECT(A1&"!B2")="","",INDIRECT(A1&"!B2"))


Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=378266