AnalystReps

Excel & Sheets practice: Two-Way & Flexible Lookups

Chapter 10 · 2 questions · included in full access

  1. Question 1 · medium

    Left lookup: product code

    Return each order's product Code (Products column A). The code sits left of the product name, so VLOOKUP can't do it — use INDEX and MATCH. Start in K2, fill to K21.

    Solve it in your browser

  2. Question 2 · hard

    Two-way regional price

    The PriceGrid sheet lists prices by product (rows) and region (columns). For each order, return the regional list price for its Product and Region. Accessories aren't in the grid — show n/a for them. Start in K2, fill to K21.

    Solve it in your browser

These questions are part of full access.

The first chapters of every track are free. Full access is a one-time payment.

See pricing