[FONT=Helvetica Neue, Helvetica, Arial, sans-serif]see attached file, im trying to find out if any of the ingredients from column D exists in column A and display whatever ingredient is found in column B, is this possible? need to go through lots of ingredients and find anything that needs special instructions [/FONT]
[FONT=Helvetica Neue, Helvetica, Arial, sans-serif]see below example[/FONT]
<tbody>
</tbody>[FONT="]
[/FONT]
[FONT=Helvetica Neue, Helvetica, Arial, sans-serif]see below example[/FONT]
butylhydroxyanisole, lavender oil, methylparaben, purified landolin, purfied water | A-alpha-C (2-Amino-9H-pyrido[2,3-b]indole) | |
Corn Starch, d&c Red #27 Aluminum Lake, d & c Red #30 Aluminum Lake, Flavors, Saccharin Sodium A-alpha-C (2-Amino-9H-pyrido[2,3-b]indole | Abiraterone acetate | |
CarboxyMethylcellulose sodium, Microcrystalline Cellulose,flavor, Acetylaminofluorene, Purified Water, Red 22, Red 28, Salicylic Acid, | Acetaldehyde | |
FD&C red #40 , propylene glycol, flavoring, sucrose, and water, soybean, oil and corn starch used as processing aids. | Acetamide | |
Famotidine, USP 20mg...... Acid Reducer | Acetazolamide | |
Purified Water, Citric Acid, Sodium Benzoate Octoxynol-9. | Acetochlor | |
Adipic Acid, FD&C Blue 1, FD&C Red 27 , FD&C Yellow 6, Acetaldehyde FD&C Yellow 10 | Acetohydroxamic acid | |
Polyehtylene, Sodium Sarcoisnate, EDTA, Quaternium-15, Carbomer, acetate | 2-Acetylaminofluorene |
<tbody>
</tbody>
[/FONT]