The Row Index Number
- 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.
- Click on the Row_index_num line in the dialog box
- Type a 2 in this line to indicate that we want HLOOKUP to return information from the second row of the table array.