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 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

Human Resource Management in Indian Context:

  Human Resource Management   in Indian Context : The term Human Resource Management implies the organizing and managing the employees of an Organization.  Human Resource is the most important asset of an Organization.  In order to properly develop and train the people of an Organization there is a dire need to recruit suitably qualified employees at proper time and at regular intervals.  The size of the Organization is relevant but the people recruited should be of high quality and value and should gain goodwill to the Organization. According to the need of the Organization w hether it is big or small Organization, the recruitment of the right people for right job is necessary.  The term Human Resource meant for all levels of Organization.  In each and every small to medium to large Organizations a well equipped Human Resource Department is essential to look after the employee relations and its management.  It is said that if the Human conte...
Post a Comment
Read more