Bayt.com

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?

Microsoft Excel Computer Science Microsoft Office Vlookup Computer Skills
user-image
Question added by dinesh kumar kr , Procurement Executive , divya auto spare parts trading llc
Date Posted: 2016/06/15
Upvote (0) Views (1) Followers (2) Answers (3) Report Question
Write an Answer
Register now or log in to answer.
Firas Shahadi
by Firas Shahadi , Human Resources Director , SAUDI UNION

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.

Write Your Answer
More Questions Like This