Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.
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
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.