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?

1 Answer 1


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:


  • 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, 2013 at 23:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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