In this tutorial, we will explain how to create an HLOOKUP function. How to use the HLOOKUP function in Excel In this tutorial, we want to Lookup the Shipping Rate of each item in the table.

I'm running into a problem with hlookup. The value that I am looking up exceeds the largest value in the array that I am looking numbers up in. Something like: f11=180, but the range of b10:bu80 ...