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:
. . . 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.