In other words, we need toapply criteria.
As a generic example, to get the largest value (i.e.
When the IF function is evaluated, it tests each value in the named rangegroup.
The named rangescoreis provided forvalue_if_true.
LARGE then returns the highest remaining score, 93, directly to the MATCH function as a lookup value.
With the return array provided asname(B5:B16).
XLOOKUP returns “Hannah” as the final result.
you’ve got the option to use INDEX to retrieve individual values, or entire rows and columns.
MATCH supports approximate and exact matching, andwildcards(* ?)
More than one condition can be tested by nesting IF functions.
XLOOKUP supports approximate and exact matching, wildcards (* ?)
