How to Use HLOOKUP Function in Excel 2013

This Tutorial will walk you through how to use HLOOKUP Function in Excel 2013. This powerful tool makes searching specific details in a spreadsheet easier than ever before. Many people shy away from learning how to use HLOOKUP function in Excel 2013 because they fear it is extremely complicated, but once you get the hang of it, the benefits are immense. The way HLOOKUP works is that it first does a horizontal search for an item and then moves onto the next row where it conducts a search for its corresponding value.

Step 1: Launch Word 2013

Step 2: Open a document that contains a table. In the case at hand, we want to find the price of peaches.

How to Use HLOOKUP Function in Excel 2013 1

Step 3: Click on the cell where you want to calculate VLOOK. In this case, we will select C4

How to Use HLOOKUP Function in Excel 2013 2

Step 4: Select the Formulas tab

How to Use HLOOKUP Function in Excel 2013 3

Step 5: Click on Lookup & Reference in the Function Library section and select HLOOKUP

How to Use HLOOKUP Function in Excel 2013 4

Step 6: In the Function Arguments window, fill in all the details. In the Lookup_value field, enter the name of the item you are looking to search. In this example, we will enter peaches. The item you are looking to search must always be in the first row. Enter the range which you wish to search through in the Table_array section. In this case, we will type in A1:X2. In Col_index_num, you have to enter the row number that you wish to search in. In this case, we wish to search in row 2. In Range_Lookup, if you want an exact match, write TRUE. If you want an approximate match, write FALSE. Click OK at the button once you are done.

How to Use HLOOKUP Function in Excel 2013 5

Step 7: The value you searched for will be in Cell C4


Leave a Reply