Why lookups connect datasets in Google Sheets - Formula Trace Breakdown

Sample Data

Two datasets: one with Product IDs and Names, another with Orders referencing Product IDs. We want to connect them to show Product Names in the Orders table.

Cell	Value
A1	Product ID
B1	Product Name
A2	101
B2	Apple
A3	102
B3	Banana
A4	103
B4	Cherry
D1	Order ID
E1	Product ID
F1	Quantity
G1	Product Name
D2	5001
E2	102
F2	5
D3	5002
E3	101
F3	3
D4	5003
E4	103
F4	7

Formula Trace

=VLOOKUP(E2, $A$2:$B$4, 2, FALSE)

Step 1: VLOOKUP(102, $A$2:$B$4, 2, FALSE)

Cell Reference Map

     A       B       D       E       F       G
1 |Product|Product |Order  |Product|Quantity|Product
  |  ID   |  Name  |  ID   |  ID   |        | Name  
------------------------------------------------
2 |  101  | Apple  | 5001  |  102  |   5    |       
3 |  102  | Banana | 5002  |  101  |   3    |       
4 |  103  | Cherry | 5003  |  103  |   7    |       

E2 references Product ID 102 to look up in A2:B4 range.

The formula looks up the Product ID in E2 within the Product ID and Name table in A2:B4 to find the matching Product Name.

Result

     D       E       F       G
1 |Order  |Product|Quantity|Product
  |  ID   |  ID   |        | Name  
--------------------------------
2 | 5001  |  102  |   5    | Banana
3 | 5002  |  101  |   3    | Apple 
4 | 5003  |  103  |   7    | Cherry

Column G shows Product Names fetched by lookup from Product IDs in column E.

The Product Name column in the Orders table shows the names matched by looking up Product IDs from the Products table.

Sheet Trace Quiz - 3 Questions

What does the formula =VLOOKUP(E2, $A$2:$B$4, 2, FALSE) do?

A Finds the order ID for the product ID in E2

B Adds the quantity to the product ID

C Finds the product name for the product ID in E2

D Counts how many products have the ID in E2

Key Result

VLOOKUP looks for a value in the first column of a range and returns a value from a specified column in the same row.