fx N/AABCSKU-4821Widget A$24.99SKU-7293Gadget B$89.50SKU-1056Tool C$12.75
🔍 Lookup

IMPORTRANGE Formula for Lookup

Import data from another Google Sheet. Copy-paste ready for Excel, Google Sheets, and Airtable.

=IMPORTRANGE("spreadsheet_url","Sheet1!A1:D100")
When you need this: When you manage a dashboard and need to pull sales data automatically from 5 regional spreadsheets.

How it works

  1. 1IMPORTRANGE pulls data from another Google Sheet by its URL.
  2. 2Specify the sheet name and range (Sheet1!A1:D100).
  3. 3Updates automatically when source data changes.

Variations

Import multiple ranges
={"Sales",IMPORTRANGE(URL1,"Sheet1!A:B");"Costs",IMPORTRANGE(URL2,"Sheet1!A:B")}
Conditional import with IFERROR
=IFERROR(IMPORTRANGE(B1,C1),"Error")

Related Formulas

VLOOKUP — Look up a value in a table by matching the first columnLookupINDEX/MATCH — Flexible lookup - more powerful than VLOOKUPLookupXLOOKUP — Modern replacement for VLOOKUP (Excel 365)LookupFILTER — Return rows matching criteria (dynamic filter)Lookup

Need a formula that's not here?

Generate custom formula →