HLOOKUP performs a horizontal lookup: it searches for a value in the top row of a table and returns the value in the same column from the row with the given index.
=HLOOKUP(value, table, index_number, [approximate_match])
Use it when the lookup table is horizontal: months, years or positions are column headings.
The manual notes: the row/column index is better calculated with MATCH than typed by hand — then the formula won't break when rows are rearranged.