Why lookups connect related data in Excel - Formula Trace Breakdown

Sample Data

This data shows a product list with IDs, names, and prices in columns A-C. Columns E-F show orders with product IDs and quantities. We want to connect orders to product names and calculate total prices using lookups.

Cell	Value
A1	Product ID
B1	Product Name
C1	Price
A2	101
B2	Apple
C2	0.5
A3	102
B3	Banana
C3	0.3
A4	103
B4	Cherry
C4	0.2
E1	Order Product ID
F1	Order Quantity
G1	Product Name
H1	Total Price
E2	102
F2	10
E3	101
F3	5
E4	103
F4	20

Formula Trace

=VLOOKUP(E2, A2:C4, 2, FALSE)

Step 1: VLOOKUP(102, A2:C4, 2, FALSE)

Step 2: Found 102 in A3

Step 3: Return value from 2nd column in row 3 (B3)

Cell Reference Map

    A       B         C       D       E       F       G       H
1 |Product ID|Product Name|Price |       |Order Product ID|Order Quantity|Product Name|Total Price
2 |101      |Apple      |0.5   |       |102    |10     |        |     
3 |102      |Banana     |0.3   |       |101    |5      |        |     
4 |103      |Cherry     |0.2   |       |103    |20     |        |     

The formula looks up the Order Product ID in column E (e.g., E2=102) and searches for it in the Product ID column A2:A4. It then returns the matching Product Name from column B.

Result

    E       F       G         H
1 |Order Product ID|Order Quantity|Product Name|Total Price
2 |102     |10     |Banana    |     
3 |101     |5      |Apple     |     
4 |103     |20     |Cherry    |     

The VLOOKUP formula in G2 returns 'Banana' because it finds 102 in the product list and gets the matching name. This connects the order data to product details.

Sheet Trace Quiz - 3 Questions

What does the VLOOKUP formula look for first?

A The Order Product ID in the product list's first column

B The product price in column C

C The quantity ordered

D The product name in column B

Key Result

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