How to use hlookup in ms excel
The syntax for the HLOOKUP function is as follows:
=HLOOKUP(lookup_value, table_array, row_index_num,
[range_lookup])
- Lookup_value: The value you want to look up in the top row of the table or range.
- Table_array: The table or range of cells where you want to look up the value. The top row of this table or range should contain the lookup_value.
- Row_index_num: The row number of the table or range from which you want to retrieve the corresponding value.
- Range_lookup: An optional argument that specifies whether you want an exact match (FALSE) or an approximate match (TRUE) to the lookup_value. If this argument is omitted, the default value is TRUE (approximate match).
Here's an example of how to use the HLOOKUP function:
Suppose you
have a table that shows the scores of different students in different
subjects, and you want to look up the score of a particular student in a
specific subject. You can use the HLOOKUP function to do this.
First, you need to select the cell where you want to display the result of the
HLOOKUP function.
Then you can enter the function as follows:
=HLOOKUP("Science", A1:E5, 3, FALSE)
In this example, "Science" is the lookup_value, A1:E5 is the
table_array, 3 is the row_index_num (which corresponds to the row where
the scores for the specific student are located), and FALSE specifies
that you want an exact match to the lookup_value.
The function will search for "Science" in the top row of the table and return
the value from the same column in the third row, which is the score of the
student in Science.
