Communiquez avec les autres et partagez vos connaissances professionnelles

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

Suivre

What is the difference between VLOOKUP and HLOOKUP?

user-image
Question ajoutée par Glenscia Amanna , Customer Service Agent , Qatar Airways
Date de publication: 2014/01/07
Mohammed Yaseen MBA  PMP®
par Mohammed Yaseen MBA PMP® , Commercial Officer , Hayat Communications

in HLOOKUP stands for Horizontal. Hence it goes about looking for the reference value in every column for the data. V in VLOOKUP stands for Vertical. It goes about looking for reference value in every Row for the data.

 

The syntax of Hlookup is =hlookup(reference value, data array, row no, logic integer). reference value is the data with the help of which you want to find some other data.

 

This data is found in data array. If the data is laid out column-wise then the header of that data will be in rows. so give row no. Eg. The data is in range C3 to K7. Row3 represents year, row4: sales; row5: expenses; row6 profit;and7 - net margin(%). in A1 you input the year. In B1 you want the net margin %. so your formula in B1 will be =hlookup(A1,$C$3:$K$7,5,0)

 

The third parameter is typed5 where as the row in which the data lies is7. This is because in hlookup we type the row no within the data array. Not the row no in the excel sheet.

Zulfiqar Ali
par Zulfiqar Ali , Data Analyst , Tech Consulting

lookup values from right first column to left many columns (vlookup)

lookup values from top first row to down many rows (hlookup)

Syed Bilal Jalal
par Syed Bilal Jalal , Estimation And Material Controller , Fawaz Trading & Engineering Services Co.W.l.l

Which means Vertical Lookup , Horizontal Lookup. In VLookup, you may retrieve the data according to columnwise and retrieve the data in rowwise in Hlookup.

 

 

Arshad Hussain
par Arshad Hussain , Senior Manager Operations , Pakistan Revenue Automation Pvt Ltd

Vertical Lookup and Horizontal Lookup

Mustafa AlTahir
par Mustafa AlTahir , Secretary Cum Admin Assistant , Bank AlBilad

Lookup is a Microsoft Excel function that searches for values in a column or row of a spreadsheet list or table. The V in VLOOKUP stands for vertical used for column, H in HLOOKUP is for horizontal used for rows.  When performing a Vlookup, each match found will return the corresponding value on the same row in the next column. For example, if you were looking for a number in a phone book you would read down the list of names until you found the name you were looking for and then move to the right (in the same row) to find the associated phone number.

Zafar Iqbal
par Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor

Vlookup reads the data vertically and Hloopup reads the data Horizontally.

Navas Abu
par Navas Abu , Seniour Accounts Payable Officer , Qatar Investment Authority

V - Vertical

H - Horizontal

Ahmed Mahdy
par Ahmed Mahdy , General Manager of engineering department , Talaat Mostafa

one is horizontal the other is vertical

Utilisateur supprimé
par Utilisateur supprimé

VLOOKUP: Use VLOOKUP instead of HLOOKUP when your comparison values are located in a column to the left of the data that you want to find. The V in VLOOKUP stands for "Vertical".

Syntax:

VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

 

HLOOKUP: Searches for a value in the top row of a table and then returns a value in the same column from a row you specify in the table. The H in HLOOKUP stands for "Horizontal."

Syntax:

HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

**Use INDEX and combination of other functions while you are using DEVELOPER ribbon/ tools in Microsoft Excel to design a FORM.

FITAH MOHAMED
par FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials

 HLOOKUP look for Horizontal. it goes about looking for the reference value in every column for the data.

 VLOOKUP look for Vertical. It goes about looking for reference value in every Row for the data.

 

 

More Questions Like This