Take the 2-minute tour ×

I understand how referencing a cell works, example being


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


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


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


share|improve this answer

Your Answer


