How to use vlookup in excel 2013 to find matches
- How to use vlookup in excel 2013 to find matches how to#
- How to use vlookup in excel 2013 to find matches download#
The good news is that we don't need to rewrite this same formula over and over-just double-click in the lower right corner of cell F5 ( you can see the small green box on the corner of the cell) to extend the formula down ( as shown above). =VLOOKUP(B5,'Supplier List'!$A$3:$G$13,2,FALSE) Our formula is working up perfectly, pulling in the supplier for the Potatoes. =VLOOKUP(B5,'Supplier List'!$A$3:$G$13,2,įinally, we'll add FALSE for an exact lookup, and then close the parentheses: Add the number 2 to the formula to pull from the second column of the lookup, and another comma. Remember that our first item to insert is the Supplier name, which is in the second column of the lookup list. Next up, we'll need to tell Excel which column to pull from. Make sure and press F4 on your keyboard during this step to create an absolute reference, which will lock in the cells to use for the lookup. Click and drag between cells A3 and G3 to select the data to lookup from. Point Excel to the lookup list.Īfter you enter the comma for the lookup cell, switch tabs and point Excel to the lookup list. Make sure and press the F4 key on your keyboard to make the formula an absolute reference (more on this later). Now, click on cell A3, and click and drag to highlight and select A3 to G13, the whole lookup table. With the formula still open, click on the Supplier List tab. Now, we need to give the formula our lookup list. Next, add a comma after "B5" so that we can enter the next part of the formula. Either click on cell B5, or type it into the formula. Remember that our primary key-the piece of data that appears in both lists-is the ingredient, so we'll use it for the lookup. Then, type " VLOOKUP( " to start the formula. On the Ingredient Orders tab, let's click in the first blank Supplier cell, F5, and press the equals sign to start the VLOOKUP formula. Let's use it to lookup each of the three fields and add it to the order list. The common field between the two tables is the Ingredient tab. Below is the "Supplier List", which will act as our lookup list. Supplier List - contains information about the suppliers, such as the supplier name and phone number.Īt the top, we have our order data, which is on the "Ingredient Orders" tab.
How to use vlookup in excel 2013 to find matches how to#
How to Use VLOOKUP in Excel: Walk Through Keep reading to walk through the written instructions, and learn some additional techniques that aren't covered in the screencast. The video walks through several examples of the VLOOKUP formula, using the example workbook. Watch and Learn: VLOOKUPįor the fastest way to learn the basics of the VLOOKUP formula, check out the screencast below. It's an example spreadsheet workbook that I created, which we'll use to walk through this tutorial.
How to use vlookup in excel 2013 to find matches download#
Free Excel Spreadsheet Downloadīefore we move on, make sure to Download the free Attachment to follow along. The best part of VLOOKUP is that I can now drag the same formula down and it will look up each unique job title. Because both sheets have an employee ID, Excel can lookup the matching job title. Using the example above, I've now written a VLOOKUP formula that looks up the employee's ID and inserts the job title into the shift data. Example VLOOKUP formula used to look up employee data. In this tutorial, I'll teach you how to master and use it. VLOOKUP is a Microsoft Excel formula that's essential for working with multiple sets of data. Quick Example of an Excel VLOOKUP Formula in Action Your data, which you want to pull a match into (the shift data).A Lookup List, which contains your "database", or basically the information (the list of employee job titles).The two lists need to share at least one piece of data in common (in the Excel VLOOKUP example above, this is the employee ID) A primary key in each list that you can use to match your data up.With a separate list of employees and their job titles, we can write a VLOOKUP formula to pull in the title from a lookup list. We want to add the employee's job title to the shift data. On the left (in the image above), we have employee shift information.
Combing two lists is a perfect situation to use a VLOOKUP. Instead of jumping between spreadsheets and typing out your matching data, you can write a VLOOKUP formula to automate the process. A VLOOKUP, short for "vertical lookup" is a formula in Microsoft Excel to match data from two lists.