- I make spice formulations. I have 80 spice formulas and 190 basic spices in my inventory sheet. On my formula sheet, each row names a product and its ingredients. On my formula sheet, the row below each ingredient shows the inventory weight in stock. I need the weight from the inventory page to automatically fill the weight cell below the ingredient. - For example, "celery" will appear in 16 spice formulas. In every formula where celery appears as an ingredient, i want the cell below the word "celery" to be filled with the number showing the weight of celery in inventory. - is there a way for the word "celery" to trigger the cell below it, to fetch the number representing the weight of celery on the inventory sheet? How can this "fetch" function be replicated for all the ingredients in my 80 formulas?
Hi Howard, You can use one of Excel's LOOKUP functions, or a combined INDEX/MATCH function, for this. -- Cheers macropod [MVP - Microsoft Word] "Howard" wrote in message news:B03B53BF-8BE6-44E8-9E25-4C6BCC22D01B@microsoft.com... >- I make spice formulations. I have 80 spice formulas and 190 basic spices > in my inventory sheet. On my formula sheet, each row names a product and its > ingredients. On my formula sheet, the row below each ingredient shows the > inventory weight in stock. I need the weight from the inventory page to > automatically fill the weight cell below the ingredient. > - For example, "celery" will appear in 16 spice formulas. In every formula > where celery appears as an ingredient, i want the cell below the word > "celery" to be filled with the number showing the weight of celery in > inventory. > - is there a way for the word "celery" to trigger the cell below it, to > fetch the number representing the weight of celery on the inventory sheet? > How can this "fetch" function be replicated for all the ingredients in my 80 > formulas?
