Hi There

What I need is the following:
This is the Formula

=IF('[Quality Scorecard Test.xls]Jan'!B2="","",'[Quality Scorecard
Test.xls]Jan'!B2)

Now Jan is the worksheet name that I need to be chnaged depending on
what mth is slected in cell A1.

Eg.

It cell A1 is Mar then I want the above formula to say Mar

Is that possible?


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