How do HLookup and VLookup differ?

HLOOKUP searches across the top row of a table and returns a value from a specified row, so its lookup direction is horizontal. VLOOKUP searches down the first column and returns a value from a specified column, so its lookup direction is vertical. Therefore, the correct choice is “HLookup searches for data in rows, while VLookup searches for data in columns.”

AI-written and checked against the verified answer.