Hlookup Function/ Hlookup Formula with Example

Hlookup Formula with example:

An advice - if one asserts to be an excel user and is sincere in his claims, then you just can't get without saying - "i don't know the lookup family in excel".
Vlookup and hlookup are the lynchpins of matching data. The alphabets "v" and "h" stand for vertical (lookup) and horizontal (lookup) respectively.
Talking about hlookup in this section, its use is less when compared to vlookup since data sets have columns arranged vertically, however, if one has read my first line, one just cannot abandon it.

The syntax for hlookup is - (lookup_value,table_array,row_index_num,[range_lookup]). To avoid you from scrtaching heads, please look below to decipher what the syntax means -
lookupvalue - value that needs to be searched in the first row
table_array - cell ran
ge  or name of the table that contains both the value to look up and the related value to return
row_index_num - serial number of the row whose value you want to return
[range_lookup] - An optional logical argument which is either TRUE or False;
TRUE - for an exact match
FALSE - for an appropriate match

HLOOKUP Example:

We have a data of sales of four regions months wise and we want the sale value in B2 cell of East Region in February 2014. Write [=HLOOKUP(B1,$B$5:$E$7,3,FALSE)] formula in B2 Cell and we can find the East Region sale value of February Month 2014 from the Sales data.