Excel Formulas

In Excel, to find the maximum, minimum and average value in the range and return the corresponding value from another range, use the INDEX MATCH formula with the AVERAGE, MAX and MIN functions.

In Excel, to look up the value in any column of the source data and return the corresponding value from the left column, use the INDEX MATCH formula.

In Excel, to vertical-lookup with if condition based on the selection of the dropdown list, use an Excel table, data validation and the IF VLOOKUP formula.

In Excel, to find lowest numeric values with multiple criteria, I will use an Excel table, data validation to create dropdown lists and the SMALL IF formula.

In Excel, to find highest numeric values with multiple criteria, I will use an Excel table, data validation to create dropdown lists and the LARGE IF formula.