No more complex INDEX+MATCH formulas or weird VLOOKUP concoctions. This also means, unlike VLOOKUP, XLOOKUP can actually look anywhere in the data and find the result, not just on the left. If you compare this with VLOOKUP, then you see that we no longer need to specify column_number or true/false to perform the search. Returns for Jamie if the name exists in column. When using XLOOKUP, you just provide 3 basic parameters (and 3 more optional parameters) and Excel does the rest. In a way, it is similar to VLOOKUP, but offers so much more. XLOOKUP allows us to search for an item in a range (or table) and return matching result. You may already know its siblings – VLOOKUP, HLOOKUP, INDEX+MATCH, LOOKUP etc.
XLOOKUP is the newest member of Excel lookup function family. In this article, learn all about the function, syntax, optional parameters and 13 xlookup examples.
Office 365 now boasts a powerful successor to the VLOOKUP function – XLOOKUP formula.
