Exact Match

The lookup mode (0) that returns a result only if the key is identical. It is the default in XLOOKUP, while MATCH needs the 0 written in.

When to use

Use it for IDs, names and codes, as in =XLOOKUP(D206,A2:A201,J2:J201,,0,). A computed number can fail with #N/A because of tiny decimal differences, but a MAX result is safe.

See Lec 06.

Appears in

No references yet.