I'm creating a restaurant pricing spreadsheet. On one sheet, I have a list of all ingredients to order with the cost per size next to it in each row. The data on this sheet looks like this:
1 Brisket $.50
2 Chicken $.24
3 Beef $.36
There are about 100 items....Now, on another sheet, I have the first menu item which will be a combination of several ingredients from the sheet I mention above....I created a dropdown list for the ingredient, but I want the cost to automatically load in the next column based on the ingredient I selected...So, if on the 2nd sheet, I selected "Beef" as the first ingredient, the cell next to that dropdown would load "$.36". How can I do this?