In Google Sheets, how do I reference a range of data in another workbook (not importing)?
I want to reference a range of data in another workbook. The only information I can find is for ImportRange() which imports all the data in the range, whereas I need to pass the reference to other functions as a range without importing it.
My guess would have been [spreadsheet key]![sheet name]!A1:C20 or something like that. Worth mentioning that the spreadsheet key and sheet name along with the range I want to reference are in cells D27 and E27 respectively within the current workbook.