Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

user-image
Question added by dinesh kumar kr , Procurement Executive , divya auto spare parts trading llc
Date Posted: 2016/06/15
Firas Shahadi
by 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.

Muhammad Farooq
by 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.

Joel Thomas
by Joel Thomas , Auditor , DME HoldingGroup

In simple words, 

V- Vertical &

H- Horizontal.

More Questions Like This

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