XMATCH functionality The XMATCH function lookups to get a specified item within an array or choice of cells, after which you can returns the item's relative placement. You can even use XMATCH to return a value in an array.(All enterprise ideas, from Enterprise E1 to E5, need an annual determination.) And the corporate is always sweetening this pot