Google spreadsheet get cell value with row and column index


Solution 1

Say the row number is in A1, and the column number is in A2, any of these should work:


Solution 2

To do so use indirect() as such:

=indirect("'PAGE ASD'!"&A2&A3)

where A2 contains the letters to column like "D" or "AA" where A3 contains the number to row like "2" or "35" and the page you are calling the data from is called "PAGE ASD"


Related videos on Youtube

Author by


Updated on August 29, 2020


  • abduIntegral
    abduIntegral almost 3 years

    How we can get value from a cell in google spreadsheet?

    I have row and column index from ROW() and COLUMN() - 1.

    In other words what is the other way to do "=B1" i have row as 1 and column as 2.

    Any suggestion, a single spreadsheet query. other than add function to spreadsheet.

    • Enissay
      Enissay over 9 years
      A bit late, but I found an answer HERE :)