'How to get the value from another sheet with rows using Google Sheets?

In addition to the previous question problem

how to update for the next row?

In the image below the error will have this formula =INDIRECT(TO_TEXT(D5)&"!$AB60"). The row below the error needs to be =INDIRECT(TO_TEXT(D5)&"!$AB61"), same goes to the next row and so on...

How to improve this formula =INDIRECT(TO_TEXT(D5)&"!$AB60") to solve the problem.

AB60 will provide different value against AB61, AB62, AB63...

google-apps-script google-sheets

Solution 1:^[1]

Try

=INDIRECT(TO_TEXT(D5)&"!$AB"&row())

if the formula is set to row#61, you will obtain what you expect

if not, add to row() a value that give you an offset

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	Mike Steelson

'How to get the value from another sheet with rows using Google Sheets?

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]