Home » Posts

XLOOKUP date of max value

To use XLOOKUP to find the date of the max value, you can use the MAX function with the XLOOKUP function. In the example shown, the formula in F4 is: =XLOOKUP(MAX(values),values,dates) where values (C4:C15) and dates (B4:B15) are named ranges.

April 14, 2025 · 1 min · 44 words · Luis Thompson

Table of Contents

Explanation

This formula is based on theXLOOKUP function.

XLOOKUP supports approximate and exact matching, wildcards (* ?)

you could use INDEX to retrieve individual values, or entire rows and columns.

Excel formula: XLOOKUP basic exact match

MATCH supports approximate and exact matching, andwildcards(* ?)

Often, MATCH is combined with the…

Excel formula: XLOOKUP with multiple criteria

Excel formula: XLOOKUP with logical criteria

Excel formula: XLOOKUP lookup left

Excel formula: INDEX and MATCH exact match

Excel XLOOKUP function

Excel INDEX function

Excel MATCH function

Explanation#

Explanation