Skip to content
Excel

MATCH function in Excel

Looks up values in a reference or array

=MATCH(lookup_value, lookup_array, [match_type])

MATCH syntax and parameters

Three arguments, two required.

  • lookup_valueanyRequired
  • lookup_arrayarrayRequired
  • match_typenumberOptional

MATCH examples

Formulas you'll actually reuse.

  1. The row position of a customer — 0 means exact match:

    =MATCH("Acme Corp", A2:A200, 0)

    Result17

  2. Which tier band a spend amount falls in — type 1 needs ascending thresholds:

    =MATCH(B2, {0, 1000, 5000, 20000}, 1)

    Result3

MATCH in Google Sheets

Same name — your formula ports as-is.

Try MATCH in the playground

Edit the example — nothing to install.

Preloaded with the MATCH formula from Example 1 — change anything and watch it respond.

Loading the editor…

MATCH errors

What they mean — and the fixes.

  • #N/A

    No match — with type 0 the value must match exactly; TRIM stray spaces, and check that numbers aren't stored as text on one side.

Related functions

More ways Excel gets this done.