Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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.

user-image
Question ajoutée par Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor
Date de publication: 2013/09/17
Zafar Iqbal
par Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor

Please participate and answer the question.

zahid ashraf
par 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
par 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
par 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

More Questions Like This

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?