Bayt.com

Communiquez avec les autres et partagez vos connaissances professionnelles

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

Suivre

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

Microsoft Office
user-image
Question ajoutée par Jismon Mathew , Teacher Assistant , Saint Pauls School Rajkot
Date de publication: 2014/05/06
Apprécier (1) Vues (16) Suiveurs (0) Réponses (3) Report Question
Ajoutez Une Réponse
Inscrivez-vous ou connectez-vous pour répondre.
Hany Hassanein
par 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
par 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
par 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.

Ecrivez Votre Réponse
More Questions Like This

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?

Obtenir de l'aide