Excel Vlookup and Hlookup

Vlookup & Hlookup

"Thanks you everyone for your response. Today we are going to discuss basic lookup functions Vlookup & Hlookup. Here I want to mention that you can use Index + Match instead of Vlookup & Hlookup since Index + Match has no restriction when you looking up data left to right and down to up. In the practical scenarios when you are in office you see most of the time data in the format where you can use Vlookup (I am not denying that you do not use Hlookup but its very rare)."

"I have seen people who do not know any function but they learnt the Vlookup and use it on daily basis in day to day work, although do not use them for complex problems but it works most of the time for them."

 

Lets start the functions :)

 

• VLOOKUP -Lookup the value in the left most column and extract value from the required column within the data range.

•  Syntax
1. lookup_value - Value you want to match
2. table_array - Range of data set (lookup value should be in first column
3.  col_index_num - Result column
4.  [range_lookup] - Optional (Approximate match-TRUE, Exact match-FALSE)

• HLOOKUP -Lookup the value in the left most column and extract value from the required column within the data range.

•  Syntax
1. lookup_value - Value you want to match
2. table_array - Range of data set (lookup value should be in first column
3.  row_index_num - Result row
4.  [range_lookup] - Optional (Approximate match-TRUE, Exact match-FALSE)

Here is the sample file you can use it to practice where I have created some of the samples..

                     Download workbook

 Here is the YouTube video, where I have explained everything..

Please get in touch for any query help or suggestion..
Youtube
Facebook Page
Twitter
Email: lkthecool@gmail.com