What is the difference between VLOOKUP and HLOOKUP?

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.

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

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

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

Vertical Lookup and Horizontal Lookup

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.

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

V - Vertical

H - Horizontal

one is horizontal the other is vertical

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.

 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.