HLOOKUP is a function that searches rows in your table. In this article we are going to explain how to use the HLOOKUP function in Excel.

A little from column A, a little from column B: XLOOKUP is the new, easier way to retrieve information across Excel spreadsheets.

Unfortunately, if you're using Excel 2019 or earlier, you won't be able to create your own functions using the methods described in this guide.