I have a workbook to keep track of items ordered, quantity ordered and total cost for the order. I have columns for the item description and the quantity. Then I have a column for the price per piece for that item. The last column calculates the total cost for that item.
I have about 40-41 items, each has it's own price per piece. I would like to be able to enter just the item and the quantity. Is it possible to have a formula (such as an "if/then" formula) that will automatically place the price per piece when I enter the item?
I have attached a workbook with the four columns and the list of items with their price per piece. I have entered two "orders" as a sample.
Bookmarks