Positions with XMATCH

How XMATCH works

• What does XMATCH do?

  It gives the position of a value in a list: 1 if it's first, 2 if it's second, and so on.

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

• How is it different from MATCH?

  XMATCH is the modern MATCH: it does an exact match by default (MATCH needs a 0 for that), and it can search from the end.

• How do I find the last one?

  Set search_mode, the fourth part, to -1: =XMATCH(E2,$A$2:$A$13,0,-1) searches from the bottom up, so it finds the latest entry in a list kept in date order. The 0 before it is match_mode: exact match.

• Is the position the row number?

  No. It's the position inside the range: with a range starting at A2, position 1 is row 2. Use it with INDEX to fetch a value from that position.