
Use the ADDRESS, MATCH, and MAX functions
to find the largest number
We learned in previous tips how to look up a single value in a list.
Now we want to determine the position of the largest value in a list
by combining three Excel functions. First, we use the MAX func-
tion to get the largest value, then we use the MATCH function to
find its relative position, and finally we use the ADDRESS function
to determine the exact cell address.
Note: The MAX function was described in Chapter 5.
MATCH(lookup_value, lookup_array, match_type)
lookup_value: The value that corresponds to the entry to be
found in a table.
lookup_array: A contiguous range of cells that ...