Food/Drug Match and Comparison Chart

Have you started putting anything together yet?

If so, care to share? If not, that may be a good place to start so we can see what you have in mind.

You dont need to be an excel expert, but Im sure you have some sort of concept in mind of what you think it should look like/show.

Based on that, could you try to mock something up - manually entered if necessary - and then we can do the work and fill in the blanks for you?

OK .. see the attached sheet (previous item in thread) for an idea of the type of data. I "envision" the data being similar to that .. columns and columns of food and drug ingredients. But aside from inputing ingredients the real issue is a "control panel" that does some or all of the following:

• compares ingredients and lists a rank order of products who have ingredient matches (products that have ingredient commonality)
• allows for an input of a product name (column header) then presents a list of ingredients
• allows for a search of a given ingredient (e.g. cellulose, sugar, magnesium, etc.) then produce a list (report) of items which have that ingredient
• allows for a search (internet) of a product to find it's ingredients then insert as a column
  

I don't know what if any is possible, but it sure would create a helpful tool.
Some existing apps that are "similar" are located at http://ecodiscoveries.com/eco-friend...ning-products/ - and I'm sure there are others. But I did not find one that addresses food and drug ingredient allergies or sensitivities directly.

To give an example of how you might accomplish bullet point #3 "...search of a given ingredient...":
1. The name of the ingredient is typed into cell A1 on Sheet2
2. Cells A2:A5 are populated using: =IFERROR(INDEX(Sheet1!A$1:D$1,AGGREGATE(15,6,COLUMN(A$1:D$1)/(Sheet1!A$2:D$13=A$1),ROWS(A$1:A1))),"")
Let us know if you have any questions.

OK ... sorry, was out for a few days. Let me try to figure this out ... and thank you. I think I see what you have done with:
=IFERROR(INDEX(Sheet1!A$1:D$1,AGGREGATE(15,6,COLUMN(A$1:D$1)/(Sheet1!A$2:D$13=A$1),ROWS(A$1:A1))),""). How would this formula change if you used "corn starch" in B1 and populated the cells below it with a revised formula?