What lookup function should be used to search for values in a specific row of a table and return values from adjacent rows?

HLOOKUP searches horizontally across a row for a value, then returns a value from a specified row in the same table. Use it when the lookup values are arranged in a row and the result is in an adjacent row; VLOOKUP is for searching down a column.

AI-written and checked against the verified answer.