Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.
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.
Please participate and answer the question.
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)
Vlookup use very easy but very powerful function
Check this link
http://office.microsoft.com/en-001/excel-help/vlookup-HP.aspx
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
