Skip to main content

VLOOKUP


How to use lookup function : VLOOKUP function in Excel

Excel Worksheet primarily supports tabulation functions which are very useful for preparing reports and financial data.  Inserting a formula in excel worksheet has the following steps:-

Suppose a value to be searched from one sheet and to be shown in another sheet vertical lookup(VLOOKUP) function is used.

FORMULA = VLOOKUP(A4,Sheet1!A1:F15,3,False).

In this formula when after inserting '=' sign add the word/function name "VLOOKUP"   inside the bracket the first item is "A4". This is the lookup cell value.   Then add the range of cells "Sheet1!A1:F15" to look for this value out of the Range – A1:F15 and add the index number "3" out of which we want to take the value.  The value required is lies in the column index no.3. Finally for an exact match add “False”.

Comments

Post a Comment

Popular posts from this blog

BLOG IDEAS FOR BEGINNERS

BLOG IDEAS FOR BEGINNERS There are various job sites available in the Internet you can create a blog about the information regarding these sites. DAYS AND THEIR IMPORTANCE  During the entire year there are various Days which are celebrated through out the year like Women's Day, Valentines Day etc. It is possible to create a blog in this category which will be useful to all. IMPORTANT PLACES AND THEIR SPECIALITIES  People are searching about various places in the world as well as in India to check the suitable location for visiting or for business purpose, people around the world usually visit various countries in that case if such a blog is created that would be beneficial for people to search their desired location and take details about these places. IMPORTANT FOOD ITEMS AND THEIR SPECIALITIES  There are various channels in TV now days working round the clock regarding preparation of food and specialties of food available at different areas in the world, so it is a ...
Post a Comment
Read more

BASIC EXCEL FORMULAS

  MS OFFICE MS Office introduced in the year 1987 has enhanced the speed of work and enriched the work life of an employee. With the introduction of this package by Microsoft all of a sudden dramatic changes occurred in the work system followed in the periods prior to 1987.  Earlier people were using WordStar and QuickPro, FoxPro, which has been replaced with latest and ultra modern package of Microsoft Office applications.  All of a sudden there occurred a dramatic change in the work style with the introduction of IBM Computers and other Companies also upgraded their Computer to run Windows and MS Office.  The easy and quick actions of these applications changed the technology and brought a revolution in the office work of each employee. MS EXCEL MS Excel is one of the packages application introduced by Microsoft.  Microsoft applications started spreading like anything its development was very quick and aspiring.  Even though MS Excel has be...
Post a Comment
Read more

APPRENTICE REGISTRATION

Those who have passed the technical education / non technical education can do apprenticeship from any one of the Industries situated in India.  In order to register in the Apprenticeship Portal you should possess qualification in technical / non technical fields. First of all you have to visit the website WWW.APPRENTICESHIP.GOV.IN  and click on the topic Apprentice Registration on the bottom of the Home Page of above Website. Please fill up all the details like Name, Father's Name, Age, Aadhar No., Mobile No., Qualification, Trade, University and the first preference i.e. if anybody having BSC Chemistry qualification can choose Chemical and for Sub-Heading Designated Trades Attendant Operator Chemical is to be selected for BSC Chemistry Qualification.  Attach required documents, photo and mark sheets. Upon successfully entering the details and captcha text you can click the submit button, which will guide you to another link and the link will tell you...
Post a Comment
Read more