HLOOKUP Formula of MS Excel

HLOOKUP Formula

The HLOOKUP formula in Excel is similar to the VLOOKUP formula, but instead of searching for a value in the first column of a table and returning a corresponding value from another column in the same row, it searches for a value in the first row of a table and returns a corresponding value from another row in the same column. The basic syntax for the HLOOKUP formula is:

scss
=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

• lookup_value is the value you want to search for.
• table_array is the range of cells that make up the table you want to search in.
• row_index_num is the row number in the table that you want to return a value from.
• range_lookup is an optional argument that specifies whether you want an exact match (0 or FALSE) or an approximate match (1 or TRUE).

For example, consider the following table in cells A1:D4:

css
  A       B       C       D
1 Name  Test1  Test2  Total
2 John    85     90    175
3 Jane    75     80    155
4 Bob     95     70    165

If you want to search for the total score of John, you could use the following formula:

php
=HLOOKUP("John", A1:D4, 4, FALSE)

This formula would return 175, which is the total score corresponding to the name "John" in the table.