So I'm making a workbook for a restaurant to calculate the ever-changing cost of food. On one sheet, inventory items are entered and the per oz cost is calculated in a table. I used a table so they can sort by provider, location, cost, etc. On another sheet I have the recipes with drop down boxes to select the inventory items and then input the amount of the item included. I need to have a cell that can reference the per oz cost of the item selected, multiply it by the amount and output the total cost. I don't know how to reference a cell that could be anywhere on the table since they change the sort every time. I feel like the R1C1 method comes into play, but I don't know how to write a formula that can read a cell with any one of 500 possible values. Any suggestions or comments will be much appreciated. Thank you.