Hello,
I am creating a workbook to calculate the food cost of recipes for a restaurant. my current system is to have a list of ingredients that use VLOOKUP to pull prices from a data table.
the problem is that the data table includes bakery and cleaning items and I need a list that only includes items used in the recipes.
is there a way to essentially reverse engineer the VLOOKUP and isolate the cells that the recipes are specifically referencing that I can then compile and print as a list?
Ps. this is my first post here so if I have been unclear or confusing please let me know,
Thank you.
Bookmarks