As part of the Microsoft Excel podcast series, Neale Blackwood CPA will explain all about the XLOOKUP function and why it is important to use. Just like VLOOKUP which is going away, XLOOKUP allows you to look up a code in a table and return entries on the same row as the code.