If you want to return a reference to specified cells see Reference form. The INDEX MATCH formula is the combination of two functions in Excel. MATCH supports approximate and exact matching and wildcards for partial matches.
The MATCH function searches for a specified item in a range of cells and then returns the relative position of that item in the range.
MATCH supports approximate and exact matching and wildcards for partial matches. The MATCH function is designed for one purpose. Copy all the cells in this table and paste it into cell A1 on a blank worksheet in Excel. Either change the match_type argument to 1 or sort the table in descending format.