CODEWITHSUNDEEP
indexinggoogle-sheets
abduIntegral
abduIntegral

Reputation: 531

Google spreadsheet get cell value with row and column index

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.

Upvotes: 17

Views: 29117

Answers (2)

user5278280
user5278280

Reputation: 21

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"

Upvotes: 2

AdamL
AdamL

Reputation: 24659

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

=OFFSET(A1;A1-1;A2-1)
=INDIRECT("R"&A1&"C"&A2)
=INDEX(A1:400000;A1;A2)

Upvotes: 12

Related Questions