Hello All,
This one is little tricky, at least for me.
This sheet represent the item name like 111,222 and so on and so forth
Col A below 1092,1449, so on and so forth, shows the ingredients used in making this product
Col B Shows the name of ingredients and that remains same from the ingredients sheets
Process We use vlookup to get the ingredients in final recipe sheet and cost the product
Query There are items which contain highly consumed ingredients like 1092, 1093 and so on and so forth
I need a formula or VBA or reporting method, where those items which contains the ingredients like 1092,1093, those items will be shown and with respective formulas and remaining items will be deleted
Output is shown in output sheet.
Bookmarks