Microsoft recently announced the upcoming release of a new function called XLOOKUP. This function will be replacing the widely used VLOOKUP, HLOOKUP and INDEX/MATCH functions to run searches in a table of Excel data. Although it may have taken many years to get to this point, Excel users now have a new function that is more user-friendly, more flexible and avoids some frustrating VLOOKUP mistakes. XLOOKUP is coming... So let’s see how the XLOOKUP function works, how to use it in your Excel formu