XLOOKUP left lookup

Intermediate

Sometimes the value you want is to the left of the value you have. VLOOKUP cannot return left, but XLOOKUP can.

XLOOKUP lets you pick the lookup column and the return column separately:

=XLOOKUP(lookup_value, lookup_array, return_array, "if_not_found")

Your task

You have a product table in A2:D5. The product name is in column B, but the SKU you want is in column A.

  1. In cell B8, return the SKU for the product in B7.
  2. If there is no match, return Not found.

Tip: Lock the table ranges with $ so the formula stays stable as you edit.

Need some help?

Hint 1

Use B7 as the lookup value and the Product column (B2:B5) as the lookup array.

Hint 2

Return values from the SKU column (A2:A5), even though it's to the left.

Hint 3

Add a not-found message so errors look clean.

Related function(s)
XLOOKUPXMATCHINDEXMATCHVLOOKUP
More exercises
INDEX-MATCH left lookupIntermediate
Look up a manager with INDEX+MATCHIntermediate
Two-way lookupAdvanced
VLOOKUP with approximate matchIntermediate
Back to exercises overview

Exercise