Often when you're entering data into a Microsoft Excel spreadsheet, you want certain cells to span multiple lines, either for addresses, multiline pieces of information or just for readability. But if ...
Most Excel lookup functions return the first match, but XLOOKUP can reverse the search direction to return the latest record.