Japanese version. The XLOOKUP, VLOOKUP, and HLOOKUP functions are functions for searching cells. They can be used in a wide range of applications and are indispensable for using Excel, along with the IF function. Function Spec. The XLOOKUP function was added in January 2020. If you can use the XLOOKUP function, we recommend you to use this function. XLOOKUP function. Searching for data. VLOOKUP function. Get the value of a specific column in the row matching the search value. HLOOKUP function. Get the value of a specific row of a column matching the search value. Basic Use. Search a table on a separate sheet from a formula. Relative cell reference … Continue reading Tips. XLOOKUP & VLOOKUP & HLOOKUP(Microsoft Excel)