Linking Sheets with Docs in Google Sheets - Cell-by-Cell Formula Trace

Sample Data

This sheet lists products and their prices. We want to link this data into a Google Sheet.

Cell	Value
A1	Product
B1	Price
A2	Pen
B2	1.5
A3	Notebook
B3	3
A4	Eraser
B4	0.75

Formula Trace

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/abc123xyz456/edit", "Sheet1!A2:B4")

Step 1: IMPORTRANGE("https://docs.google.com/spreadsheets/d/abc123xyz456/edit", "Sheet1!A2:B4")

Cell Reference Map

  A       B
1 Product  Price
2 Pen      1.50
3 Notebook 3.00
4 Eraser   0.75

Formula references external sheet range Sheet1!A2:B4

The formula imports cells A2 to B4 from the external Google Sheets document.

Result

  A       B
1 Pen      1.50
2 Notebook 3.00
3 Eraser   0.75

The imported data appears in the current sheet showing product names and prices exactly as in the source sheet.

Sheet Trace Quiz - 3 Questions

What does the IMPORTRANGE formula do in this example?

A It sums the prices in the current sheet.

B It creates a chart from the data.

C It copies data from another Google Sheet using the URL and range.

D It deletes data from the source sheet.

Key Result

IMPORTRANGE("spreadsheet_url", "sheet_name!range") imports data from another Google Sheet.