Google spreadsheet get cell value with row and column index
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)
To do so use indirect() as such:
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
05 : 27
Google Sheets Row and Column Lookup
16 : 12
Google Sheets - INDEX & MATCH - Part 1
16 : 10
Google Sheets - Get Last Non-Empty Cell in Row or Column
02 : 48
Google Sheets INDEX | Use INDEX Google Sheets to Extract Data | Google Sheets Function
08 : 04
INDEX MATCH to get whole Row/Column Excel Formula | index match vs vlookup | multiple results
07 : 15
How to Get the Last Value in a Column in Google Sheets
10 : 58
Google Apps Script Search Sheet Get cell data with Google Sheets select column data or entire sheet
abduIntegralUpdated on August 29, 2020
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 over 9 yearsA bit late, but I found an answer
Critical issues have been reported with the following SDK versions: com.google.android.gms:play-services-safetynet:17.0.0