Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is Vlookup and how we can use this?

In excel this function is very useful on the same sheet and among the different sheets to get the required data by using the unique value.

Data Marts Aqua Data Studio ADO.NET Data Services HP Data Protector Vlookup
user-image
Question added by Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor
Date Posted: 2013/09/17
Upvote (8) Views (8) Followers (5) Answers (4) Report Question
Write an Answer
Register now or log in to answer.
Zafar Iqbal
by Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor

Please participate and answer the question.

zahid ashraf
by zahid ashraf , System engg , HP

Vlookup , it is a function used to find out the availability of a particular word , from a range in excel vertically . It can be used as "=Vlookup("Word need to be search","Range eg A1:C10",Coumn index number, True/False)

 

Muhammad Jahanzaib Khan
by Muhammad Jahanzaib Khan , Accountant , Mairaj Uddin Traders

Vlookup use very easy but very powerful function

 

Check this link

http://office.microsoft.com/en-001/excel-help/vlookup-HP.aspx

Atif Tanveer
by Atif Tanveer , Decision Support Specialist , Hamilton Health Science

VLOOKUP function searches value in the left-most column of table and returns the value in the same row based on the given column number.

try this example

http://spreadsheets.about.com/od/excelfunctions/ss/vlookup.htm

Write Your Answer
More Questions Like This

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

Get Help