Excel HLOOKUP Step by Step Tutorial

The Row Index Number

The row index number argument ( Row_index_num ) indicates which row of the Table_array contains the data you are after.

For example:

• if you enter a 1 into the row index number, HLOOKUP returns a value from the first column in table_array;


• if the row index number is 2, it returns a value from the second row in table_array.

For this tutorial

Note: For help with these instructions, click on the image above.

1. Click on the Row_index_num line in the dialog box


2. Type a 2 in this line to indicate that we want HLOOKUP to return information from the second row of the table array.

• How to Use HLOOKUP in Excel
• Entering the Tutorial Data
• Starting the HLOOKUP Function
• The Lookup Value
• The Table Array
• The Row Index Number
• The Range Lookup
• Using HLOOKUP to Retrieve Data
• Excel HLOOKUP Error Messages