The XLOOKUP in Excel belongs to the family of lookup and reference functions. It is one of the most useful functions in the popular Microsoft spreadsheet software. XLOOKUP is the easiest way to search for specific data entries in a cell range. The entries in a previously defined cell range are displayed in a formatted form. Sounds familiar? This principle is also used by the VLOOKUP. However, with the more flexible Excel-XLOOKUP you can look up not only one, but several entries. It is also possible to search values vertically and horizontally in your sheet.
What does this mean in practice? Imagine you have a digital customer database as an Excel file and you are looking for the address and phone number of a certain person. With XLOOKUP you can now search for the corresponding entries by name and have the desired information displayed immediately. It doesn’t matter if the searched values are in a column, row or in a table on another page. This means that the XLOOKUP replaces not only the VLOOKUP function, but also the HLOOKUP.