Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the usage of "VLOOKUP" in Excel?

Microsoft Excel
user-image
Question added by AFZAN WASIM , STORE EXECUTIVE , AL ROSTAMANI TRADING COMPANY
Date Posted: 2014/10/01
Upvote (1) Views (5) Followers (1) Answers (2) Report Question
Write an Answer
Register now or log in to answer.
Ahmad Ghieth
by Ahmad Ghieth , Technical Manager , Ambience Jordanian Lighting

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

FITAH MOHAMED
by FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials

agree with mr ahmad  

Write Your Answer
More Questions Like This