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 #.
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?