What is the usage of "VLOOKUP" in Excel?

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.

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

Upvote (1)

Downvote Reply () Report

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

agree with mr ahmad

Upvote (0)

Downvote Reply () Report

Any template in excel for financial data analysis?
Top Answer: Thank you, Its a good question See More

Answers (1)
What is vlookup and what is benefit of it?
Top Answer: If you are a long time Excel user, you may already be very familiar with the VLOOKUP function. It works g ... See More

Answers (1)
How can we apply two vlookups together on a single cell?
Top Answer: if I get your question correctly you can use: concatenate logical operators functions OR(), AND() ... ... See More

Answers (2)
"If you can't convince them, confuse them"- do marketing and sales departments follow this quote these days?
Top Answer: <p>Not my sales & marketing management. RESPECT { Customer Service and Customer Care} is a ... See More

Answers (14)

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.

Get Help