XLOOKUP practice

XLOOKUP searches a range and returns the matching item from another range, with a built-in result for a missing value. Below are the 4 Google Sheets exercises on Sheetsdrill that use it, each checked instantly in your browser.

Syntax

XLOOKUP(search_key, lookup_range, result_range, [missing_value], [match_mode], [search_mode])

What people get wrong

The fourth argument replaces IFERROR around the lookup, and the lookup range can sit to the right of the result range.

Google Sheets exercises that use XLOOKUP

• Look left with XLOOKUPLevel 3Pro
• A friendly "Not found"Level 3Pro
• Latest status in a logLevel 3Pro
• Commission rate tierLevel 3Pro