That information will be used to calculate the line total for each item (assuming we enter a valid quantity).įor the purposes of keeping this example simple, we will locate the product database on a separate sheet in the same workbook:
#How to use vlookup in excel list box series
This is how it’s going to work: The person using the invoice template will fill in a series of item codes in column “A”, and the system will retrieve each item’s description and price from our product database. Let’s create an example of this: An Invoice Template that we can reuse over and over in our fictitious company.įirst we start Excel, and we create ourselves a blank invoice: Each time someone enters a valid item code, the system would retrieve all the necessary information about the corresponding item. Typically you would use this sort of functionality in a reusable spreadsheet, such as a template. If all you need is one piece of information from the database, it would be a lot of trouble to go to to construct a formula with a VLOOKUP function in it. Which of these pieces of information will it pass you back? Well, you get to decide this when you’re creating the formula. In the example above, you would insert the VLOOKUP function into another spreadsheet with an item code, and it would return to you either the corresponding item’s description, its price, or its availability (its “In stock” quantity) as described in your original list.
0 kommentar(er)
