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!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.

[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.