This page isn't translated yet, so its text is in English. Function names and formulas are shown in your Excel language.

Excel function · Lookups

RECHERCHEH(HLOOKUP)

Finds a value in the top row of a table and returns a value from the same column.

What it does

HLOOKUP is VLOOKUP turned sideways: it searches across the first row of a table and returns a value from a row below it.

=RECHERCHEH(lookup_value; table_array; row_index_num; [range_lookup])

Arguments in square brackets are optional, and … means you can add more of the same. In this Excel language, arguments are separated by ;

lookup_value: What to look for in the top row.
table_array: The table, with the values to search in its first row.
row_index_num: Which row to return, counting from 1 at the top of the table.
range_lookup: FALSE for an exact match. TRUE, or leaving it out, finds the closest smaller value in a sorted row.

How many visitors came in February?

The formula in B5:

=RECHERCHEH(B4;B1:D2;2;FAUX)

Result: 150

Feb is the second column of B1:D2. Row 2 of that table holds the visitors, so the result is 150.

Counting rows from the top of the sheet instead of from the first row of the table.
Leaving out FALSE and getting an approximate match on labels that aren't sorted.

Excel translates function names, and in some languages the argument separator too. Type the name your Excel shows.