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.

Try using the LARGE function to find the largest value in the array. Then use that in an IF statement to choose whether to perform the lookup or just return the value.