AnalystReps

Excel & Sheets practice: VLOOKUP Mastery

Chapter 9 · 4 questions · included in full access

  1. Question 1 · easy

    Stock level with VLOOKUP

    For each order, look up the product's current Stock from the Products sheet (the 4th column of Products!B2:E8). Start in K2, fill to K21.

    Solve it in your browser

  2. Question 2 · medium

    Commission band by target

    On Reps, find each rep's commission Band for their Target using the slab table on the Commission sheet (approximate match). Start in E2, fill to E7.

    Solve it in your browser

  3. Question 3 · easy

    The inserted column

    A colleague inserts a new column into the middle of the Products table. Which lookup is most likely to start returning the wrong field without any error?

    Solve it in your browser

  4. Question 4 · medium

    Approximate match gone wrong

    Your commission VLOOKUP uses TRUE (approximate match). After someone sorts the Commission table largest to smallest, the bands come back wrong. Why?

    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