Menu
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.
867
Description. You can use the ADDRESS function to obtain the address of a cell in a worksheet, given specified row and column numbers. For example, ADDRESS(2,3) returns $C$2. As another example, ADDRESS(77,300) returns $KN$77.
Please enter this formula: =INDIRECT(ADDRESS(F1,F2)), and press Enter key to get the result, see screenshot: Note: In the above formula, F1 and F2 indicate the row number and column number, you can change them to your need.
An example of how to use INDEX in Google Sheets is to return the value at a certain row and column in a given range. For example, if you have a range of cells A1:A10 and you want to return the value at row 3 and column 2, you would use the INDEX function like this: =INDEX(A1:A10,3,2).
We can use a formula that is based on the INDEX and MATCH functions to lookup a value in a table in a Google Sheet. Unlike in excel where the result is entered with CRTL+SHIFT+ENTER, the result is entered with the enter key only for Google Sheets.
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)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
