You're a retail pricing analyst pulling regional list prices for a markdown analysis. Cells A1:E6 hold a 5-region × 4-product price grid:
- Column A (rows 2–6) lists the regions: North, South, East, West, Central.
- Row 1 (columns B–E) lists the products: Widget, Gadget, Tool, Cable.
- The intersection of each row and column gives that region's list price for that product.
Three (region, product) pairs you need prices for are pre-populated in columns G and H.
Your task:
- In column I (Price), write an INDEX/MATCH/MATCH formula that pulls the right cell from the 2D grid for each (region, product) pair.
- Use absolute references so the formula drags cleanly to I3 and I4.
Graded cells: I2, I3, I4.
Open this problem on a desktop to attempt it.