Linking cells with a diffrent sheet with 2 cells

[Angelofdoom]

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

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

so C1 would the input to this formula, i would only have to put A1 i
cell C1 and the formulat will be '=Sheet1!A1' and if i put B2 in cel
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

 

[vezerid]

Angel

The INDIRECT function will do what you want:

=INDIRECT("Sheet1!"&C1)

HTH
Kostis Vezerides

 

[Angelofdoom]

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