# ingredient

1. ### Product of Index & matches - need help to make more efficient

Hi Everyone, I'm looking for some help to simplify the following: 1) I have 1 sheet with a large table A1:D4 showing sales volume (Mt) per productcode (column A) and per months of June, July and August (row 1) <tbody> June July August ProductCode1 100 50 200 ProductCode2 150 80 120...
2. ### VLOOKUP or IF formula??

I have a sheet where we calculate usage of an ingredient we use every day based on process orders. Daily Ingredient Usage The SAP GI can change if I fix a process order (didn't issue enough flour for the target) I need a vlookup (maybe an IF) that will lookup the date on above spreadsheet...
3. ### Returning list of column headers if a value in column A is detected

I have a list of chemicals and ingredients in a chart and want to pull in a list of ingredients needed if I enter a the name of a chemical in column A into a cell. <colgroup><col style="width: 100px"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col...
4. ### Having Trouble Tackling a larger formula: need to return multiple values based on multiple criteria

Hi All I have a fairly tricky situation that I'm trying to solve that I'm not entirely sure is possible. I'll give a brief explanation below but if anyone wants to attempt it I can give a more detailed examples of the data. I am trying to create a list that generates the items I need, in...
5. ### Move To New Row After Comma

I have a list of ingredients in cell A1. Each ingredient is separated by a comma (,). How can I move each ingredient to its own row? EXAMPLE: ORIGINAL CELL A1 = water, sodium lauroyl methyl isethionate, glycerin WANTED CELL A1 = water CELL A2 = sodium lauroyl methyl isethionate CELL A3 =...
6. ### Index name of a product

Hi guys, First of all, my apologies because I am attaching a picture. The excel add-in to upload files didn't seem to work with me I have this table of products. Some products have one active ingredient and some have more than one. I need help with a formula (in another table) that finds...
7. ### Math problem using Excel

Say i have Ingredients A and B that form a solution with water. Ingredient A can be added up to 15 % of water solution volume. Ingredient B can be used up to 5 % of solution volume. Ingredients A and B in total can be used up to 15 % of solution volume. I need a calculator to count how much in...
8. ### Power Pivot to get sequence of ingredients

Have a need to get a list of ingredients we will need based on a sequence list(schedule we will run) and an ingredient list. Here is simple list of data to show the tables I have and the output table based on these tables. I know it could be done with a macro but would prefer to have done with...

### This Week's Hot Topics

• SUMPRODUCT active link formula
Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
• Block certain cells in condition met in cell A
Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
• IF FUNCTION FIRST, THEN WITH INDEX AND MATCH
Hi, Below formula works well, =(INDEX('PRICE LIST'!\$C\$7368:\$C\$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!\$A\$7368:\$A\$7679)*(WORKSHEET!P28='PRICE...
• Match data from 3 columns to return data from the correct 4th column
Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
• VLookup
Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
• Defining a range
Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back