HLOOKUP

This function looks for a value in the top row of a table or array and returns the value from the same column for the row you specify. 

Syntax

HLOOKUP(lookup-expression,search-range,row-offset,{method})

Arguments

lookup-expression	The value you are looking for.  This can be a number, text string, or reference.
search-range	The range to search.
row-offset	By default, the function searches the first row of the range defined by search-range.  However, use row-offset to instruct the lookup to search a different row.  The first row in the range is always 1, the second is 2, and so forth. If this value is less then 1 or greater than the number of rows in the defined range, then the function returns the error #REF!
method	The method of searching for the value.  The default is 1. If method < 0 Assumes decreasing values. Returns the smallest value that is greater than or equal to lookup-expression value. If method is 0 Returns first exact match. If method > 0 Assumes increasing values. Returns the largest value equal to lookup-expression value.

Example

HLOOKUP(500,A2..F5,2)

This function searches cells A3, B3, C3, D3, E3, and F3 for the value 500.   Row 3 is searched since it is the second row in the range A2 through F5.