What is the usage of "VLOOKUP" 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

agree with mr ahmad