Spreadsheet reference cell value specified by string

Use =INDIRECT() to reference a spreadsheet cell using a string for the column and row in A1 notation or R1C1 notation.

For example, if cell A1=123, a cell containing =INDIRECT("A1") would equal 123.

Did this help you? Please let me know with a comment. Thank you
Posted .

Comments (RSS)

Leave a comment