What are the difference between vlookup and hlookup equations in excel?

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

Question ajoutée par dinesh kumar kr , Procurement Executive , divya auto spare parts trading llc
Date de publication: 2016/06/15

Apprécier (0) Vues (1) Suiveurs (2) Réponses (3) Report Question

par Firas Shahadi , Training And Development Director , Muhayal Assir National Hospital

vlookup returns it's value from vertical array.

hlookup returns it's value from horizontal array.

par Muhammad Farooq , Assistant HR , Mossassa-tu-Mariam

VLOOKUP allows you to search a table that is set up vertically.

HLOOKUP is the exact same function, but looks up data that has been formatted by rows instead of columns.

par Joel Thomas , Auditor , DME HoldingGroup

In simple words,

V- Vertical &

H- Horizontal.

Apprécier (0)

Which is the most used Function of MS EXCEL i.e Vlookup, Hlookup etc for organization ?
Top Answer: <p>Vlookup</p> Voir Plus

Réponses (11)
What are the differences between the function VLOOKUP & HLOOKUP?
Top Answer: vlookup takes a value then it compares that value with another vertical array of values then returns the ... Voir Plus

Réponses (5)
What is "VLOOKUP" function in excel?
Top Answer: Vlookup is very important while updated old flies with New file with the same report Example Every month ... Voir Plus

Réponses (4)
What is the use of VLOOKUP function in Excel?
Top Answer: VLOOKUP is an extremely useful tool, and learning how to use it is easier than you think! VLOOKUP, one of ... Voir Plus

Réponses (1)

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