You're an inventory analyst reconciling line items from a vendor invoice that lists products by name — but your warehouse system identifies everything by SKU. Columns A–D hold the master catalog: SKU (A), Product (B), Category (C), Price (D).
Three product names you need SKUs for are pre-populated in column F. Notice that the lookup key (Product) sits in column B, but the value you need (SKU) is in column A — to the left of the key. VLOOKUP can't do this; INDEX/MATCH and XLOOKUP can.
Your task:
- In column G (SKU), write an INDEX/MATCH formula that returns the SKU for each product name.
- The formula must be drag-down friendly with absolute references on the master range.
Graded cells: G2, G3, G4.
Open this problem on a desktop to attempt it.