XMATCH

Syntax

=XMATCH(lookup_value, lookup_array, [match_mode], [search_mode])

Description

Returns the relative position of an item in an array or range of cells.

Related Functions