BInterest

H in the Hlookup function stands for the Horizontal. i.e. row wise lookup function in excel. It searches the value in the rows of table and returns the value in the same column in an table from the row you have specified during the lookup function syntax. More simpler way to understand the same would be Hlookup Function helps you find the corresponding value in an table when you want to find for the value in the given column in number of rows.

Syntax :

(lookup_value,table_array,row_index_num,range_lookup)

• lookup_value : is the value to be found in the first row of the table. Lookup_value can be a value, a reference, or a text string.
• Table_array : Table in study (Table used as the reference to get the lookup value).
• Row_index_num : is the number of the row from which the reference value could be got in the table in study.
• Range_lookup : It is a logical parameter, that specifies between exact match of the lookup_value in the corresponding column or approximate value (It can be defined as TRUE OR FALSE) OR (1 OR 2) in the Formula.

Example of Hlookup :

Lets see the above example in the HLookup Function Sheet, in the first example in 7th row, H1 is the lookup_value, B1:J5 is the table_array, Row-index_num is 4 and Range_lookup is false which would get you the result of 157.

Possible outputs of the Hlookup Value could be :

• =HLOOKUP(H1,B1:J5,4,FALSE) would get you the result of 157.
• =HLOOKUP(D1,B1:J5,6,FALSE) would get you the result of #REF! as Row_index_num is outside the table_array.
• =HLOOKUP(I1,B1:J5,3,FALSE) would get you the result of 0.
• =HLOOKUP(J1,B2:J5,3,FALSE) would get you the result of #N/A as lookup_value is outside the table_array.

You can follow me on Twitter at http://twitter.com/binterest.Do stay tuned to Binterest.com for more, Best Way 2 do it, Subscribe to Binterest's Feed Updates