Difference between vlookup and hlookup

Question

Accepted Answer

VLOOKUP searches for a value in the first column of a table and returns a value in the same row. HLOOKUP does the same but in the first row.

VLOOKUP searches vertically while HLOOKUP searches horizontally
VLOOKUP requires the lookup value to be in the first column of the table while HLOOKUP requires it to be in the first row
VLOOKUP is more commonly used than HLOOKUP
Example: VLOOKUP can be used to find a student's grade based on their name in a table of grades
Example: HLOOKUP can be used to find the price of a product based on its name in a table of prices