Excel HLOOKUP Function usefull for office .

HLOOKUP is an Excel function to lookup and recover data from a explicit row in table.

 The "H" in HLOOKUP stands for "horizontal", where lookup values appear in the first row of the table, moving horizontally to the right. Hlookup supports imprecise and exact matching, and wildcards (* /?) for discovery limited matches.

Syntax :- =HLOOKUP (value, table, row_index, range_lookup)Enter

Example Step:-

1.value :- The value to look up.

2.table :- The table from which to repossess data.

3.row_index :- The row number from which to retrieve data.

4.range_lookup :- (optional) A boolean to indicate exact match or     imprecise match.Default = TRUE = imprecise match.