Combining XMATCH and INDEX

  Exploring XMATCH The XMATCH function will return the relative position of an item within a range or an array. We will firstly look at a basic XMATCH construction to return a result and then look at an example that includes XMATCH and INDEX together. Constructing XMATCH (syntax) The syntax for XMATCH is similar to […]