LOOKUP

This function looks for a value a table or array and returns the value from the cells where a match is found.. 

Syntax

LOOKUP(lookup-expression,search-range,result-range,{method} )

Arguments

lookup-expression	The value you are looking for.  This can be a number, text string, or reference.
search-range	The range or ranges to search.
result-range	If a match is found, the function returns those values to the range specified.
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,A12..F15,-1)

This function searches cells A2 through F5 for the value 500.  Results are placed in cells A12 through F15.