Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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:

=Sheet2!INDIRECT("A"&A1)

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

=Sheet2!A2

The formula returns #ERROR (error - parse error)

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

share|improve this question

1 Answer 1

up vote 2 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:

=INDIRECT("Sheet2!A"&A1)

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

 
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.