Horizontal lookup function; searches for a key in the first row of a range and returns the value from a specified row in that column.
=HLOOKUP("Q1", A1:E2, 2, FALSE) looks in row 1 of A1:E2 for "Q1" and returns the value from row 2 of the same column.
