Learning & how-to

Useful details · 1

• Look up a value with XLOOKUP

  XLOOKUP searches any column and returns any other, left or right.

  Formula: =XLOOKUP(A2, Products[SKU], Products[Price], "Not found")

  Steps

  0 of 4 done

  1. 1. Click the cell where the result should go and type =XLOOKUP(
  2. 2. Pick the value to find, e.g. the SKU in A2.
  3. 3. Select the column to search in, then the column to return.
  4. 4. Add a message for when nothing matches, like "Not found", and press Enter.

  Where this came from

  =XLOOKUP(A2, Products[SKU], Products[Price], "Not found")visible text · 0:12