Using the MATCH function to find the RELATIVE POSITION of an item in a list.
Commonly used with other Lookup functions like the INDEX, VLOOKUP (for column index), the OFFSET function etc, the MATCH function is powerful in identying location of an item in a list. The MATCH function always return a number (numeric) and locating an item in a list in a specific column/row in excel is never easily achievable without a MATCH function. #exceltips #tutembe #excelutilities #appexcel #exceltriks #uspscaleyourskills #excel #appexcelanalytics