HLOOKUP function in Excel

HLOOKUP looks across the first row of a table and returns a value from another row.

Syntax

=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

Argument	Required?	What it is
lookup_value	Required	The value to look for, such as an ID or name.
table_array	Required	The table to search. The value you look for must be in its first column (or row for HLOOKUP). Lock it with $.
row_index_num	Required	Which row of table_array to return, counting the first row as 1.
range_lookup	Optional	FALSE (or 0) for an exact match, which you almost always want. TRUE finds an approximate match in sorted data.

=HLOOKUP("Mar",A1:E4,2,FALSE) finds Mar in row 1 and returns the value from the 2nd row (Sales).

From the lesson HLOOKUP Function.

Type the formula yourself and get it graded instantly, no Excel needed.

HLOOKUP looks across the first row of a table and returns a value from another row.

=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

Argument	Required?	What it is
lookup_value	Required	The value to look for, such as an ID or name.
table_array	Required	The table to search. The value you look for must be in its first column (or row for HLOOKUP). Lock it with $.
row_index_num	Required	Which row of table_array to return, counting the first row as 1.
range_lookup	Optional	FALSE (or 0) for an exact match, which you almost always want. TRUE finds an approximate match in sorted data.

=HLOOKUP("Mar",A1:E4,2,FALSE) finds Mar in row 1 and returns the value from the 2nd row (Sales).

From the lesson HLOOKUP Function.

Type the formula yourself and get it graded instantly, no Excel needed.