HLOOKUP in Excel

HLOOKUP is a function used to search for a value in the top row of a table and retrieve corresponding data from a specified row below, making it suitable for horizontally organized data and complementing VLOOKUP, which is used for vertical layouts.

When to Use the HLOOKUP Function in Excel

• The HLOOKUP Function is beneficial when data is organized horizontally.
• It retrieves information from a specific row based on a value in the top row.
• The function can be used for both exact and approximate matches.

• lookup_value: The value we want to search for in the top row of the table.
• table_array: The range of cells that contains the data. The top row of this range will be searched for the lookup_value.
• row_index_num: The row number in the table_array from which to return a value. The top row is row 1.
• [range_lookup]: An optional argument. Use TRUE for an approximate match (default), or FALSE for an exact match.

Full explaination step by step

Step 1   create the data

Step 2   create a headings and tables

Step 3  Write the formula of hlookup

Formula ( =HLOOKUP(CELL ADDRESS LOOKUP VALUE LOCK BY F4,CELL ADDRESS TABLE ARREY LOCK BY F4,ROW NUMBER)

LOCK BY F4       CELL ADDRESS TABLE ARREY

ROW NUMBER  2

CTRL  +  D DOWN 

fill roll no and click enter