How to use vlookup in excel step by step pdf

#HOW TO USE VLOOKUP IN EXCEL STEP BY STEP PDF HOW TO#
#HOW TO USE VLOOKUP IN EXCEL STEP BY STEP PDF DOWNLOAD#

Here when we place data in E3, which is the first name from our given table, the formula will give us the Last Name.

We can select the table too instead of the entire row In the formula, you can see written 2 before False as a column indicator because we want data to be retrieved from column # 2 from the selected range.

We have made the table by using Vlookup, we will find the Last name of the person from their first name all the data has to be available in the table which we are providing the range to find the answer within (A:C in this case). In cell F2, we are using VLOOKUP Formula. Here for this example, letвЂ™s make a table to use this formula suppose we have the data of students as shown in the image below.

#HOW TO USE VLOOKUP IN EXCEL STEP BY STEP PDF DOWNLOAD#

Is this your first time on Easењњlick? WeвЂ™ll be more than happy to welcome you in our online community.You can download this VLOOKUP Examples Excel Template here вЂ“ VLOOKUP Examples Excel Template Example #1 вЂ“ Exact Match (False or 0)

#HOW TO USE VLOOKUP IN EXCEL STEP BY STEP PDF HOW TO#

If you found this tutorial helpful, give us aВ like and watch other video tutorials by Easењњlick Academy.В Learn how to use Excel in aВ quick and easy way!

How to Calculate Difference Between Two Dates in Excel.

More tutorials on other popular functions are listed in the description list below.ДonвЂ™t miss out aВ great opportunity to learn: Well, this was aВ short video on how to use one of the most favourite functions in Excel вЂ“ VLOOKUP. If we enter an ID which is not present in the data table, Excel will not show any valid result. If we type in вЂ1013вЂ™, Excel will show that the last name of the employee with this ID is Walsh. So, if we enter for example вЂ1004вЂ™, Excel will find for us the Last Name of the employee with the ID 1004, which is, in this case, Williams. Once we enter an ID, it will look for the exact match of what we entered, and based on it, Excel will provide us with the employeeвЂ™s family name. ThatвЂ™s why thereвЂ™s no result in the field вЂLast NameвЂ™ for the time being. The VLOOKUP function is complete and correct, but we didnвЂ™t enter any Employee ID. Click on вЂEnterвЂ™ and the jobвЂ™s done! The Examples of How the VLOOKUP Function Works in Excel In this case, we want Excel to look up the employeeвЂ™s family name based on the exact match of the employeeвЂ™s ID, so weвЂ™ll use вЂFalseвЂ™ here. But if you are looking for the exact match, you need to type in вЂFalseвЂ™. If you enter вЂTrueвЂ™, Excel will look for an approximate match.

In the last part, the formula requires one of the words вЂTrueвЂ™ or вЂFalseвЂ™. The Last Part of the Formula вЂ“ True or False Function Enter aВ comma again, and weвЂ™ve got the last bit ahead of us. Since we want to look up the last name, and this information is stored in the second column, weвЂ™ll type in вЂ2вЂ™. The column numbering in the selected area is standard вЂ“ 1, 2 and 3. What Excel needs here is the number of the column that contains the information we want to retrieve. To select the area of search, you can mark the whole table, add aВ comma and weвЂ™ll move on to the next step. This means that the Employee ID column must be on the left, and the Last Name column needs to appear on the right in the table. The function looks to the right, which means that if you want it to work, the information based on which you carry out your search must be located to the left of the information you want to find. Here we need to mention that VLOOKUP works with the information thoroughly organised. This area must include both details вЂEmployee IDвЂ™ as well as вЂLast NameвЂ™. The next piece of information Excel needs is the area which will be searched. The Employee ID will be entered in the cell G2, so weвЂ™ll click and select that cell to include it in the formula and enter aВ comma. The VLOOKUP function вЂ“ The Details Needed to To Make the Function WorkДЇirst, we need to state according to what Excel should look for the piece of information we need to find, which will be вЂEmployee IDвЂ™. To make the function work, weвЂ™ll need to enter some more details. Type in the equal sign, then вЂVLOOKUPвЂ™, and select the suggested function. In this case, it will be the cell next to вЂLast NameвЂ™. To begin, select the cell where you want the search result to appear. Today, weвЂ™re gonna have aВ look at how to look up the last name of an employee based on their ID. The VLOOKUP function is particularly useful if thereвЂ™s aВ great deal of data stored in the data table in which you regularly need to carry out the search for certain information. 3 The Examples of How the VLOOKUP Function Works in Excel

How to use vlookup in excel step by step pdf