MATCH practice

MATCH returns the position of a value in a range. Below are the 3 Excel exercises on Formuladrill that use it, each checked instantly in your browser.

Syntax

MATCH(search_key, range, [search_type])

What people get wrong

Use 0 as the search type for an exact match; the default 1 assumes the range is sorted.

Excel exercises that use MATCH

• Look left with INDEX and MATCHLevel 3Pro
• Finishing positionLevel 3Pro
• Price gridLevel 3Pro

Often used together with: INDEX