Most Excel lookup functions return the first match, but XLOOKUP can reverse the search direction to return the latest record.

We've all been there: staring at a massive spreadsheet until the rows start to blur. It turns out Microsoft added a specialized data entry tool decades ago, but never included it on the ribbon by ...