Web Applications Stack Exchange is a question and answer site for power users of web applications. 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 have a separate sheet with some data where a user's input will reference the row number of a sheet. I'm trying to reference that sheet by inserting the column letter and taking a number input from a cell to make up the row #.

I've tried:


where A1 in the current sheet holds a value of 2, thus I want it to obtain


The formula returns #ERROR (error - parse error)

How (if possible) can I reference it in that way?

share|improve this question
up vote 3 down vote accepted

Figured it out... took me a while...

INDIRECT() has to wrap the entire reference. In order to achieve what I needed, the formula looked like this:


share|improve this answer
If you want to learn more about using Indirect you can check this tutorial: spreadsheetpro.net/… (Jacob put the extra explanation link in this answer's comments) – Javaaaa Jul 28 '13 at 23:30

Your Answer


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.