Microsoft® Excel® 2010 Formulas & Functions Inside Out

HLOOKUP()

Syntax. HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)

Definition. This function looks for a value in the top row of a cell range or in an array constant. Depending on the passed arguments, the function returns an entry in the references table.

Arguments

• lookup_value (optional). Must evaluate as text, a number, or a logical value. This is the value you search for in the top row of the array.

  Note

  The search for text is not case-sensitive.

• table_array (required). A reference to a (named) cell range or an array constant (numbers and text must be in braces).

• row_index_num (required). Must evaluate to a positive integer not greater than the number of rows in table_array. This argument indicates the number of the row from which the ...