Sample Usage IMPORTRANGE("https://docs.google.com/spreadsheets/d/abcd123abcd123", "sheet1!A1:C10") IMPORTRANGE(A2,"B2") Use table references: IMPORTRANGE("https://docs.google.com/spreadsheets/d/abcd123abcd123", "DeptSales[Sales Amount]") Learn more about how to use tables in Google Sheets. Use named range: IMPORTRANGE("https://docs.google.com/spreadsheets/d/abcd123abcd123", "Sales_total") Learn mo