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

How to Use Mail Merge in Microsoft Word

How to Use Mail Merge in Microsoft Word Use mail merge to create and print too many letters and other documents to different persons. Mail merge is used to create a set of documents, such as a form letter(interview call/offer letters) that is sent to many candidates.  Each letter has unique information.  For example, in letters to candidates, each letter can be personalized to address each candidate by name.  The mail merge process requires the following steps: Set up the main document.  The main document contains contents which will be used in each document. Connect the document to a data source.  A data source is a file that contains the information to be merged into a document. Normally we can use excel file contains the names and addresses of the recipients of a letter.  Microsoft Office Word generates a copy of the main document for each item, or record, in your data file.  If your data file is a mailing list, these item...
Post a Comment
Read more

How to Install Wampserver in Windows 10

What is WAMPSERVER :  WAMPSERVER IS A LOCAL WEBHOSTING PACKAGE HOW TO INSTALL WAMPSERVER IN WINDOWS 10 WAMP stands for Windows Apache  MySQL  and PHP. WAMPSERVER is a server for executing Hypertext Preprocessor programming language. Normally PHP is used as a server side programming language in building beautiful web applications and websites. In a  web development  activity WAMPSERVER playing the role of displaying the webpages without the help of a  Browser .  HTML and CSS is also used on side by side to display the webpages and ultra modern web applications and graphical presentations. What is PHP?   PHP was initially "Personal Home Page" and now it is  known as Hyper-text Pre Processor".  PHP is very widely used to build stunning web applications and websites.  There are many such websites built with PHP.  PHP was initially developed by 'Rasmus Leadoff' which is further developed by PHP Team.  The introdu...
Post a Comment
Read more

LEARN HOW TO CREATE A REGISTER FORM IN HTML

LEARN HOW TO CREATE A REGISTER FORM IN HTML In order to create a database and table in the database require XAMPP Webserver.  For XAMPP download and install visit site  https://www.apachefriends.org/index.html. After installing the Server localhost C:\xampp and open  'htdocs'  folder  where you will create your form  form1.html ,  close the folder and on desktop click shortcut of XAMPP and it will be opened at the bottom of the screen then click on the icon appearing on the taskbar then a pop box XAMPP control panel will appear on the screen then click on the first start button and second start button.  Then the port numbers will appear in front of the start button and start button will become stop button also click second button for starting MySql then the button will become stop button, when you close the local host you need to click on both the stop buttons before shutting down the pc or laptop. Then click on the button next to start ...
Post a Comment
Read more