XLOOKUP is an Excel function that searches a range or array and returns a matching value. It replaces VLOOKUP and HLOOKUP: it looks in any direction, returns an exact match by default, doesn’t break when you insert or move columns, and can handle a \u201cnot found\u201d message on its own. If you know VLOOKUP, XLOOKUP does the same job with far fewer headaches.<\/p>\n\n\n\n\n\n\n\n
This guide walks through the syntax and the most common real-world uses, with copy-ready examples.<\/p>\n\n\n\n
XLOOKUP takes a value you want to find, looks for it in one list, and returns the matching item from another list. For example, you have a product code and you want the matching price, or an employee name and you want their department. XLOOKUP finds the code or name and hands back the value sitting alongside it.<\/p>\n\n\n\n
It was released to replace the older VLOOKUP and HLOOKUP functions and is available in Microsoft 365, Excel 2021, and Excel for the web.<\/p>\n\n\n\n