named ranges used:
Beef ='Inventory List'!$B$29:$M$30
Buns ='Inventory List'!$B$44:$M$48
Cheese___Other_Dairy ='Inventory List'!$B$44:$M$48
Chicken ='Inventory List'!$B$31:$M$38
Drinks ='Inventory List'!$B$20:$M$28
Fish ='Inventory List'!$B$39:$M$43
Fries ='Inventory List'!$B$71:$M$73
Inventory_Items ='Inventory List'!$D$7:$D$92
Item_Code ='Inventory List'!$B$7:$B$92
Other___Food ='Inventory List'!$B$74:$M$83
Paper___Packaging ='Inventory List'!$B$84:$M$92
Produce___Vegetable_Items ='Inventory List'!$B$60:$M$70
Seasonings___Condiments ='Inventory List'!$B$7:$M$19
Unit_Cost ='Inventory List'!$L$7:$L$92
units ='Inventory List'!$M$7:$M$92
data validation in column D:
=INDEX(INDIRECT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A19," ","_"),"&","_"),"/","_")),0,3)
c19: =IFERROR(INDEX(Item_Code,MATCH($D19,Inventory_Items,0)),"")
E19: =IFERROR(INDEX(Unit_Cost,MATCH($D19,Inventory_Items,0)),"")
G19: =IFERROR(INDEX(units,MATCH($D19,Inventory_Items,0)),"")
Bookmarks