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

Home > Back-end > How to get the value from another sheet with rows using Google Sheets?

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

Time：04-21

In addition to the previous question

CodePudding user response：

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