Revision history [back]

Index Match Function

1. Identify the range of data that you want to use as the source for the index match function.
2. Determine the column you want to retrieve data from.
3. In the cell where you want to display the result, type "=index(range,column,match(lookupvalue,lookuprange,0))".
4. Replace "range" and "column" with the appropriate range and column you identified in steps 1 and 2.
5. Replace "lookup_value" with the value you want to search for.
6. Replace "lookup_range" with the range that contains the values you want to search.
7. Press enter to complete the formula.

Maxifs Function

1. Identify the range of data that you want to use as the source for the maxifs function.
2. Determine the criteria you want to use to select the maximum value. For example, you may want to find the maximum value of sales for a particular month.
3. In the cell where you want to display the result, type "=maxifs(range,criteria_range1,criteria1,...)".
4. Replace "range" with the appropriate range of values you identified in step 1.
5. Replace "criteria_range1" with the range of cells that contains the criteria you want to use to filter the values.
6. Replace "criteria1" with the value or range that you want to use as a filter for the criteria range you identified in the previous step.
7. Add additional criteria ranges and criteria values as needed, separated by commas.
8. Press Enter to complete the formula.