How simple can be explain "V LOOKUP" in Excel?

this question was answered before ,

Vlookup is used to find value in different file or sheet and return the value related from the same raw

for example :

=VLOOKUP(A2,'Subscribers Bandwidth'!G:G,1,0)

the above statement will search for value A2 in sheet 'Subscribers Bandwidth' in column G and then return the same value if found.

=VLOOKUP(A2,'Subscribers Bandwidth'!G:G,2,0)

the above statement will search for value A2 in sheet 'Subscribers Bandwidth' in column G and then return the NEXT value in raw if found.

hope this was clear

Simply 

The function vlookup 

Used for 

Find the value in the column at the left of the table 

Then return the value located in the same row of the column you specify 

***

the table must be  in order by default 

Formula

=vlookup(lookup_value;table array ;col_index_num;rang_lookup)

Example 

Column A contains1,2,3,4 

Column B contains a kk, ll, nn.mm 

And when you want to put number in cell c1 shows each value that appears in the same row in a cell d1 

The equation which is written in d1 

= (VLOOKUP (C1; $ A $1: $ B $4;2;0) 

When c1 contains2'll get "ll "

When c1 with4 'll get "mm"

note*************

 when you will get C1  empty the result will be in # N / A that  means that the value of c1 cell  non-existent  in column a spicfied  array