What is the difference between HLookup and VLookup? - ProProfs Discuss
Topics-
Products +
     

What is the difference between HLookup and VLookup?

Asked by R. Jones on Jun 13, 2019

+ AnswerRequest Answer
...

1 Answer

I. Klose

I. Klose
Accountant, Franklin

Answered on Jul 05, 2019

The HLookup Function is beneficial for creating horizontal lookups, but it is not very popular in comparison to VLookup. This Function is one of the essential tasks in Microsoft Excel. The VLookup has mainly vertical tables.

Vlookup is the most popular and oldest Lookup formula in Excel used to perform lookups within the column in a table. The HLookup Function is utilized when data is listed in rows instead of columns, and it searches for a value horizontally, through the rows. When executing a VLookup, each match found will return the corresponding amount on the same row.

 Reply

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.