In some Excel workbooks, you might have a simple product pricing table, with the product name in one column, and the product price in the next column. With a simple VLOOKUP formula, you can get the price for any product.
In the video below, there’s a different kind of pricing table. There are product names in the first column, with quantity pricing information in the next four columns.
Continue reading “Find Product Price Based on Quantity with Excel VLOOKUP and MATCH”