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.