CellReps

Lookups

Lookups

VLOOKUP, XLOOKUP, INDEX and MATCH · 0 of 4 solved

  1. Look up a product price with VLOOKUPLevel 1
  2. Show a friendly message when XLOOKUP finds nothingLevel 2
  3. Return a salary from a column left of the employee codeLevel 3
  4. Find a sales commission from a slab table with approximate matchLevel 3