INDEX [users.business.uconn.edu]

Answer: MATCH and INDEX. Use MATCH and INDEX together to, e.g., select the largest value in a column and display its label. MATCH. Returns the relative position of an item in an array (a row or column) that matches a specified value in a specified order (similar to argmax and argmin functions in mathematics). MATCH has 3 arguments, separated by ... ................
................