I have a list of about 100 items with four different prices for each items, depending on the number of items sold, and I can't seem to find any logical system in how the prices are set.
If I select an item from a list in cell a1, and insert the number of the given item in b1, I want c1 to provide one of the four prices, depending on the number of cell b1, and choose from the right four step price list by the item in a1. Please help me!