#HOW TO USE VLOOKUP IN EXCEL HOW TO#
#HOW TO USE VLOOKUP IN EXCEL DOWNLOAD#

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.

Ingredient Orders - contains the list of ingredient requests from our chefs.

There are three pieces we need to add for each order: The chefs have given us a list of ingredients to order, and we need to insert information about the supplier. Let's say that we manage a restaurant and are placing our weekly orders to suppliers. Use the tabs 'Ingredient Orders' and 'Supplier List' for this Excel VLOOKUP example.

#HOW TO USE VLOOKUP IN EXCEL 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 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.

How to use vlookup in excel