If you have encountered the error message “There’s a problem with this formula” in Microsoft Excel, you are not alone. Many users report this error appearing ...
Most Excel lookup functions return the first match, but XLOOKUP can reverse the search direction to return the latest record.