Sunday, October 10, 2021

Lookup the Last Value in Excel [XLOOKUP & INDEX / MATCH]

Looking up the last value is usually not the default when you perform lookups with various lookup functions. However there are times when you want to find the last item in a list or array that matches a criteria. With the newer XLOOKUP function, it makes this job very easy. The only catch is that XLOOKUP is on newer version of Excel. If you didn't have the latest Excel version, you can still perform a lookup for the last item and that can be done with a combination of the INDEX and MATCH functions.

No comments:

Post a Comment