How to Use VLOOKUP to Fetch Pricing Information for Products in Excel 20 Let’s look at each example now in more detail, before also investigating how to use VLOOKUP to fetch data from another workbook. In our second example, we want Excel to fetch a customer’s address automatically when we enter their customer ID into an order. Using VLOOKUP, Excel 20 compares your order with your catalogue and comes back with the price. You know that the customer wants the Green album from R.E.M. In our first example, we want Excel to be able to tell you the value of a customer order. When an order comes in, you record that order in the order book using the customer number into your spreadsheet. You have a list of orders from customers in your order book, your catalogue containing all your prices, and a database of your customer’s details.Įach customer, once they have made a purchase, is assigned a customer number and their details are entered into the database. Lastly, we will look at using VLOOKUP to look up data in another workbook.Įxamples of How to Use VLOOKUP in Excel 20.Secondly, VLOOKUP will be used to complete a user’s name and address in the order by looking up the customer’s customer ID in our customer database and returning their details.
Firstly, we will be using VLOOKUP to fetch price information on products from our pricing catalogue so that we can determine the value of an order.To illustrate how to harness the power of VLOOKUP, we will be looking at some examples: What VLOOKUP does in essence is that it looks for a value within a table of data and returns some specific information related to that value. Today I will be looking at one of the most powerful Excel functions, VLOOKUP, and how it can be used in formulas. In this example, we’ve selected the entire table from "Apples" down to "7" (A2:C12).Robbie mostly writes about Skyrim but also occasionally sheds light on the oddities of Microsoft applications such as Excel and Outlook.īoth Excel 20 have an enormous number of functions available. Highlight the data where you want VLOOKUP to use for its search in the table_array box. Once we’ve set up VLOOKUP properly, Excel will show the product’s Price in cell F4 when we type the product name in cell F3.Ħ. Here, our lookup value is F3 since we will input the name of a product such as “Apples” in that cell block. Specify the cell where you will enter the value for the data you are looking for. Choose “VLOOKUP” towards the bottom of the drop-down window.ĥ. Select “Lookup & Reference” icon on the Ribbon.Ĥ. Click on “Formulas” tab at the top of the window.ģ.
Select the cell where you would like to calculate the VLOOKUP formula.Ģ. Just follow these 10 steps on how to use VLOOKUP in Excel 2013 and start using it today.ġ. To the beginner, VLOOKUP can look a little intimidating at first. You’ll probably find this VLOOKUP training very useful if you find yourself constantly needing to consult a table to find the same data.įor example, if you want to quickly find a price of a product, simply enter the name of the item into Excel and VLOOKUP will find the price immediately. One tool in particular is the Vertical Lookup, or VLOOKUP, which looks at the vertically-aligned tables and quickly finds the data that you're looking for.
The average user doesn't seem to take advantage of them either. Microsoft Excel 2013 has a numerous amount of useful tools and functions. Security+ Administrator Career Training Program.Network Security Administrator Specialist.Medical Front Office Assistant and Administration.Medical Front Office and Electronic Health Records.Electronic Health Records and Reimbursement Specialist.Funding Sources for Individual Career Training.
0 kommentar(er)
