I need help to dynamically fetch a value from another Google spreadsheet like this: FILE1 has 0
or 1
values in column G. Now I want to fetch the G column value from FILE1 with a row number specified in B7 in FILE2.
I've learned that INDIRECT
could solve the dynamic bit fetching from column G with B7 as row number like this:
=INDIRECT("G"&B7)
but I just can't make it work together with IMPORTRANGE
:
=IMPORTRANGE("KEY";indirect("Sheet1!G")&B7)
=IMPORTRANGE("KEY", "Sheet1!G"; indirect(&B7))
Above examples just give me wrong interpretation of formula error. Is this possible to achieve with Google Sheets and if yes, how?