0
0
Google Sheetsspreadsheet~10 mins

Cross-sheet references in Google Sheets - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

Sheet1 has a list of products and their prices. Sheet2 wants to show the cost of the same products by referencing Sheet1.

CellValue
Sheet1!A1Product
Sheet1!B1Price
Sheet1!A2Apple
Sheet1!B21.20
Sheet1!A3Banana
Sheet1!B30.80
Sheet2!A1Item
Sheet2!B1Cost
Sheet2!A2Apple
Sheet2!B2
Sheet2!A3Banana
Sheet2!B3
Formula Trace
=Sheet1!B2
Step 1: Sheet1!B2
Cell Reference Map
Sheet2
  A      B
1 Item   Cost
2 Apple  --> Sheet1!B2 (1.20)
3 Banana --> Sheet1!B3 (0.80)
Sheet2 column B cells reference prices from Sheet1 column B for the matching products.
Result
Sheet2
  A      B
1 Item   Cost
2 Apple  1.20
3 Banana 0.80
Sheet2 shows the prices for Apple and Banana by pulling values from Sheet1 using cross-sheet references.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the formula =Sheet1!B2 return when placed in Sheet2!B2?
AThe value in Sheet2 cell B2
BThe value in Sheet1 cell B2
CThe value in Sheet1 cell A2
DAn error because of cross-sheet reference
Key Result
Cross-sheet references use the format SheetName!CellReference to get data from another sheet.