Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

Microsoft Office
user-image
Question added by Jismon Mathew , Teacher Assistant , Saint Pauls School Rajkot
Date Posted: 2014/05/06
Upvote (1) Views (16) Followers (0) Answers (3) Report Question
Write an Answer
Register now or log in to answer.
Hany Hassanein
by 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
by 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
by kareem zock , Project Development Lead , iSolution

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.

Write Your Answer
More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.

Get Help