Vlookup & Hlookup function of Excel .

Object of this Block:

 understanding of Vlookup and Hlookup data analysis function  of Excel .

Useful term :

Hear,

H stands for Horizontal

V stands for vertical

At, What Point of Data Analysis Vlookup and Hlookup will help us?

Mr. B having two table of data with one similar column. both table having following data:

Table 1.	Column Name
Row No.	A	B	C
1	Country	Capital	National Language
2	India	Delhi	Hindi
3	Japan	Tokyo	Japanese
4	UK	London	English
5	Italy	Rome	Italian
6	France	Paris	French

Table 2.	Column Name
Row No.	A	B
1	Country	National Language
2	India
3	Japan
4	UK
5	Italy
6	France

Requirement of Mr.B:

Now, Mr.B wants to find Country-wise National Language for Table 2. from Table No.1.  

Answer of it is “Vlookup”

Now, We See How Vlookup will work.

Vlookup require Following Details : (Vlookup value, Table array, Column Index no., Rang lookup)

Mr.B insert Vlookup in Table 2. Cell no. “B2“ First.

By simply typing “=Vlookup(A2,Table1!D15:F19,3,0)”

Now,

A2 : Stands for India Will find from Table 1. First Column.

Table1!D15:F19 : Stands for considering Total Data for Analysis.

3 : Stands for if India will find in Table 1. than Print Column no. 3 Data.

0 : Stands for an Exact match (i.e. India=India, Not India=Ireland ) (you may use 1 for an Approximate match)

For Remaining Cell Answers Mr.B Just Copy The cell”B2” Formula and past it in all.

But, Before pasting formula Mr.B Mack Small Change.

 (i.e. “=VLOOKUP(A2,Table1!$D$15:$F$19,3,0)”

This Change Mack Same Table array of Vlookup in all cell formula, so that Vlookup work perfectly.

Now You can Try Hlookup on any Horizontal Data 

         

Grow the info.