In this case, that value is 849900.
This number is then supplied to the MATCH function as the lookup value.
Thelookup_arrayis the same range (C3:C11), and thematch_typeis set to “exact” with 0.
See this example for details:Information about the max value.
(2) In case of duplicates (i.e.
MAX ignores empty cells, the logical values TRUE and FALSE, and text values.
MATCH supports approximate and exact matching, andwildcards(* ?)
Often, MATCH is combined with the…
