hi folks i'm relatively new to excel and fumbling around trying to do what i presume will be a fairly complex spreadsheet over a few sheets, what i'm trying to do is have a way to cost out menu recipes and have these costings update as prices change. i was thinking i would need to have all my prices on a separate sheet and pull from this sheet for each recipe. what i am having trouble with is linking a word and a price together i was thinking of having drop down boxes for each "stock" item say Rump steak by the kg and then it links it to the per kg price for rump from another sheet.
is this even possible?
thanks
Todd
recipe card.jpgstock list.jpg