HLOOKUP
Use HLOOKUP and VLOOKUP to find values in large lists. Use HLOOKUP when searching in rows and VLOOKUP when searching in columns.
You may have two tables or arrays of data containing different information. For example, Table A may contain a list of product codes and the total sales for each product. Table B has the same product codes but has the name of the products instead of the sales. In Table A you can see which product code had the highest sales but you cannot see the name of the product. You use HLOOKUP to look for the code in Table B and return the corresponding product name.
The range_lookup parameter specifies whether to look for an exact match (True) for the value you enter. If you use True, your data must be sorted in ascending order.
Syntax
HLOOKUP(lookup_value, table_array,row_index_number[,range_lookup=TRUE])
Example
=HLOOKUP(F3,A30:B99,2,FALSE)
Lookup_value can be a reference to a cell containing the value you want to lookup.
Table_array is a range of cells.
The row_index_number is the number of the row from which the value is returned.