sorry if this is not the right place to post this- i have not found a forum place for google sheets
how can I import a range from a different gsheet into the INDEX formula
i tried
=index(importrange("URL","Sheet1!B2:G1285"),MATCH(G3,B2:B1285,0))
and i got this error:
Circular dependency detected. To resolve with iterative calculation, see File > Spreadsheet Settings.
Bookmarks