Most Excel lookup functions return the first match, but XLOOKUP can reverse the search direction to return the latest record.
👉 Learn how to find the rate of change from a table of values. The rate of change of a set of data listed in a table of ...