I know how to link to a another cell in a diffrent sheet, its =Sheet1!A1
(for a1 in sheet 1)

i am trying to use another cell to say what should be on the end of
'=Sheet1!'

so C1 would the input to this formula, i would only have to put A1 in
cell C1 and the formulat will be '=Sheet1!A1' and if i put B2 in cell
C1 the formula would be '=Sheet1!B2'

this was my attempt but i faild:
=Sheet1!(=C1)

Can it be done? if so plz tell me.
thanks for any help.


--
Angelofdoom
------------------------------------------------------------------------
Angelofdoom's Profile: http://www.excelforum.com/member.php...o&userid=31572
View this thread: http://www.excelforum.com/showthread...hreadid=512677

Angel

The INDIRECT function will do what you want:

=INDIRECT("Sheet1!"&C1)

HTH
Kostis Vezerides

thank you. this problem has been annoying me for a few days.


--
Angelofdoom
------------------------------------------------------------------------
Angelofdoom's Profile: http://www.excelforum.com/member.php...o&userid=31572
View this thread: http://www.excelforum.com/showthread...hreadid=512677