Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .