Hi Mike,

sorry had gone out. You need to put that formula in all your instances.
Its a one time job you have to do. For instance, just replace one
formula and see if you are getting your expected result.

Lets say this is one of your formulae.
=IF('[Quality Scorecard Test.xls]Jan'!B2="","",'[Quality Scorecard
Test.xls]Jan'!B2)
If you are working in one workbook, you need not use the file name,
=IF('Jan'!B2="","",'Jan'!B2)
This will work as fine.

Now you want to change the "Jan" in the above formula to be whatever
month you select in A1. Note that A1 shold be text "Jan" or "Feb".
While entering a month in A1, enter "Jan" (without quotes) and not a
date.

Substitute the above formula by the one I gave, and with Jan in A1 in
the score sheet, it should give the same result as your formula is
currently giving.

=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