3

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?

3

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)

  • 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 clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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