Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.
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.