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

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

متابعة

What is the difference beween lookup and vlookup functions in Microsoft Excel

user-image
تم إضافة السؤال من قبل Jismon Mathew , Teacher Assistant , Saint Pauls School Rajkot
تاريخ النشر: 2014/05/06
Hany Hassanein
من قبل Hany Hassanein , Microsoft Trainer , Egyptian Banking Institute

VLOOKUP (Vertical Lookup) function to search by first column of a range of cells (must to be Left to Right Direction), and then return a value from any cell on the same row of the range using the number of column you want to search in.

=VLOOKUP(LookupValue,TableArray,ColumnNumber)

LOOKUP function returns a value from a range of cells (one row or one column),

=LOOKUP(LookupValue,LookupRange,ResultRange) 

Note: LookupRange & ResultRange must be the same number of cells.

Divyesh Patel
من قبل Divyesh Patel , Assistant Professional Officer- Treasury , City Of Cape Town

The V in VLOOKUP stands for 'Vertical,' which implies that it will work only on columns, where LOOKUP can scan columns or rows. Note also that LOOKUP is restricted to a single column or row, not a range, as VLOOKUP can span.

kareem zock
من قبل kareem zock , Founder & Blogger , Techwebies

VLOOKUP function to search the first column of a range of cells, and then return a value from any cell on the same row of the range

LOOKUP function returns a value from a range (one row or one column) or from an array.

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