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 2 Excel exercises on Formuladrill 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.

Excel exercises that use XLOOKUP

• When the code does not existLevel 3Pro
• Return from the leftLevel 3Pro