I need help to dynamically fetch a value from another Google spreadsheet like this: FILE1 has
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:
but I just can't make it work together with
=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?