Difference between Vlookup and Hlookup

HFMedia 8:00 PM Application, Guidance, Microsoft Office, Microsoft Office Excel, Software, Windows

Here is the difference between VLOOKUP and HLOOKUP:

VLOOKUP: excel formula that is used to search data in the first column of a table then returns the value of the right column that has been determined its position. (Vertical / column)
HLOOKUP: an excel formula that is used to find data in the first row of a table then returns the value in the bottom that has been determined its position. (Horizontal / row)

To read examples of HLOOKUP, you can click HERE.

To read examples of VLOOKUP, you can click HERE.

No comments

Subscribe to: Post Comments ( Atom )