What are the differences between the function VLOOKUP & HLOOKUP?

vlookup takes a value then it compares that value with another vertical array of values then returns the matching value or a value next to it in the same row

hlookup takes a value then it compares that value with another horizontal array of values then returns the matching vaue or a value below it 

 ^_^ I AGREE WITH ALL ANSWERS  

V  Stands for Vertical

- Means you will lookup the data value  that exist in Rows

Ex: ID001-300 

ID  -   Name       NoOfTrns     Value

100 - Arnold        50              1,500

101 -Jane            30              1,300

H Stands for Horizontal.. 

Means the value on below items we need to lookup horizontally

Ex:

NoOfTrans  

Value 

lookup you search data entries that exist in  Columns.

Like: 

I think VLOOKUP for vertical search while HLOOKUP for horizontal search.

Vlookup searches in Columns and when the function finds the intended value it presents it in the cell of the respective row. while Hlookup does the opposite and searches in rows and when the value is found it presents it in the cell of the repective column.