What is the work of hlookup

Question

Accepted Answer

HLOOKUP is a function in Excel used to search for a value in the top row of a table and return a corresponding value from a specified row.

HLOOKUP stands for Horizontal Lookup.
It is commonly used to retrieve data from a table based on a specific criteria.
The function takes four arguments: lookup_value, table_array, row_index_num, and range_lookup.
lookup_value is the value to search for in the top row of the table.
table_array is the range of cells that contains the table.
row_index_num specifies which row in the table to return the value from.
range_lookup is an optional argument that determines whether an exact match or an approximate match is required.
HLOOKUP is often used in conjunction with VLOOKUP to perform two-dimensional lookups.
Example: =HLOOKUP(123, A1:D10, 3, FALSE) will search for the value 123 in the top row of the range A1:D10 and return the value from the third row.

Accepted Answer

Hlookup is pick the data in horizontal.

Popular interview questions of Senior MIS Executive