ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

What are the differences between the function VLOOKUP & HLOOKUP?

user-image
تم إضافة السؤال من قبل Ahmed Maher allam , Senior IT Consultant & System Admin (Lecturer & Trainier) , KGL
تاريخ النشر: 2015/04/16
Ahmed Maher
من قبل 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
من قبل FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials

 ^_^ I AGREE WITH ALL ANSWERS  

Reynaldo Corvera
من قبل 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: 

 

 

 

هاشم المشارقة
من قبل هاشم المشارقة , 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
من قبل 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.

المزيد من الأسئلة المماثلة