XMATCH formula to get a position in an array

Don't miss the new XMATCH formula in the new Office 365 version of Excel. XMATCH will return the position in a list of the searched for value. So this formula:


=XMATCH(F2,$A$2:$A$11,0)


. . . will find the value in F2 in the array in column A between rows 2 and 10.



If you enter a 2 (instead of a 0 which looks only for an exact match) the XMATCH formula will be able to run a wildcard search if the searched for value ends with an asterisk.