To use the HLOOKUP function, you will need the row number from the table that has the data you want returned to the cell with the HLOOKUP function.

Question

Quizplus · Accepted Answer

The HLOOKUP function searches for a value in the first row of a table and returns the corresponding value in the same column from a specified row in the table. Therefore, you need to know the row number where the data you want to retrieve is located, and enter it as the row_index_num argument in the HLOOKUP function.

To Use the HLOOKUP Function, You Will Need the Row