Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

What are the differences between the function VLOOKUP & HLOOKUP?

user-image
Question ajoutée par Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions
Date de publication: 2015/04/16
Ahmed Maher
par Ahmed Maher , System Administrator & IT Consultant , Axis Solutions (KGL)

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 

FITAH MOHAMED
par FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials

 ^_^ I AGREE WITH ALL ANSWERS  

Reynaldo Corvera
par Reynaldo Corvera , Planner , Flexible Packaging

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: 

 

 

 

هاشم المشارقة
par هاشم المشارقة , Key Account Manager , Advanced United Systems Ltd. ( A member of Taj Holding Group)

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

Assaad El Hindi
par Assaad El Hindi , IT Manager , Golden Tulip Galleria Hotel

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.

More Questions Like This