Nitrousoxide
New Member
- Joined
- Feb 27, 2018
- Messages
- 2
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 width="100"></colgroup><tbody>
</tbody><style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
Here's the table
And then here's the format of the user would enter the chemical in and in the third column how I'd like it to output the value.
<colgroup><col width="131"><col width="120"><col width="171"></colgroup><tbody>
</tbody><style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
Is there a way to get it to pull the list of ingredients if someone enters a chemical desired into first cell under "chemical wanted" based on the first table?
Chemical B | Chemical A | Ingredient 1 | Ingredient 2 | Ingredient 3 | Ingredient 4 | |
Chemical A | 1 | 1 | 1 | |||
Chemical B | 1 | 1 | ||||
Chemical C | 1 | 1 |
<colgroup><col style="width: 100px"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"></colgroup><tbody>
</tbody>
Here's the table
And then here's the format of the user would enter the chemical in and in the third column how I'd like it to output the value.
Chemical Wanted | Amount Wanted | Chemicals Needed |
Chemical A | Ingredient 2 | |
Ingredient 3 | ||
Ingredient 4 |
<colgroup><col width="131"><col width="120"><col width="171"></colgroup><tbody>
</tbody>
Is there a way to get it to pull the list of ingredients if someone enters a chemical desired into first cell under "chemical wanted" based on the first table?