Vlookup & Hlookup

What is Vlookup  ?

• Vlookup is a function to lookup up and retrieve data in a table. The "V" in Vlookup stands for vertical, which means the data in the table must be arranged vertically, with data in rows.
• When the Vlookup function is called, it searches for a lookup value in the leftmost column of a section of our spreadsheet called the table array. The function returns another value in the same row, defined by the column index number.
• If we have a well structured table, with information arranged vertically, and a column on the left which we can use to match a row, we can use Vlookup.

Example :
 The formula to apply Vlookup is " =VLOOKUP(lookup value,table array,column index number,range lookup) ".

In the above we have used exact match so, the value is same as in the above.

 In approximate match it depends on the lookup value it returns the next largest value that is less than our specific lookup value.

What is Hlookup ?

• Hlookup is a function to lookup and retrieve data from a specific row in table. 
• The "H" in Hlookup stands for "horizontal", where lookup values appear in the first row of the table, moving horizontally to the right. 
• Hlookup supports approximate and exact matching.

Example :
The formula to apply Hlookup is " =HLOOKUP(lookup value,table array,row index number,range lookup) ".

Important points :

• Vlookup only looks right.
• It always finds the first match and it is not case-sensitive.
• The fourth argument, range_lookup is optional and defaults to true, which means it'll do an approximate match by default.
• For approximate matches, data must be sorted.
• It can merge data in different tables.