Linking cells with a diffrent sheet with 2 cells

  • Thread starter Thread starter Angelofdoom
  • Start date Start date
A

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
 
Angel

The INDIRECT function will do what you want:

=INDIRECT("Sheet1!"&C1)

HTH
Kostis Vezerides
 
Back
Top