Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I understand how referencing a cell works, example being

=Sheet1.A1

However, if I'm in Sheet2 and cell B1 contains Sheet1, and cell C1 contains A1.

Is there any way to write the reference such that it uses the values from B1 and C1 to determine where the reference should point to?

share|improve this question
1  
You would use Sheet1!A1 –  kobaltz Mar 20 '12 at 23:30

1 Answer 1

up vote 3 down vote accepted

You need to use ! after the sheet name for the basic formula, like this

=Sheet1!A1

You can use INDIRECT to convert a text reference to an actual one, so for your example try

=INDIRECT(B1&"!"&C1)

Sheet names with spaces (and some other characteristics) also need single quotes around them e.g.'Sheet one'!A1 so to cover all possible sheet names you can change to this version

=INDIRECT("'"&B1&"'!"&C1)

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.