XLOOKUP function

Any more experienced user often uses the VLOOKUP function and is aware of its features and drawbacks. Therefore, the XLOOKUP function was created which can replace the VLOOKUP, HLOOKUP and LOOKUP functions. It also supports wildcard characters used to replace multiple (*) or single character (?) which makes it very flexible and probably your choice for some future spreadsheet calculations.

Searching through data ranges

In practice, it often happens that we have tables that are in a mutual relationship. Similar to the database, the value of a table column column may be a key by which we can access the columns of another table. In this text, we will discuss the functions used to search through data ranges. If you master them, it’s quite certain that this will quickly become one of your favorite Excel tools.