if function for finding specific cells in formulae

Hi all,

I have 6 columns with many different calculations to obtain individual mixtures for each cell. The numbers for these calculations are derived from other cells. I would now like to have an if function that gives me a yes in a new column for whenever a certain cell appears in one of the calculation.

E.G

calculation: in cell A1 is =e1+h1+k1
in cell B2 is =e2+g2+i2
in cell c2 is =f2+h2+i2 etc

Now I want a formula that gives me a yes in cell d if any calculation in the respective row, range a-c contains a value from column f.

Can that be done?

Or in other words, I need an if function that searches for criteria in existing formulas.

Thanks heaps.

I have a long list of different ingredient mixtures in these formulas. They are all foodstuff. The value produced is the overall protein content. However, other factors apart from protein are also relevant so I need to know which of these mixtures contain certain components (let's say vegetables).

If I have to do that by hand it would take me ages and is prone to mistake. Also, I could not change the variables to look later eventually for different components.

So is there no way of finding out which formula links to which cells and use use that as criteria?

I hope that works.

Where it says now only "yes" in column R it would be great to have a formula that identifies if a specific cell from columns S-Z appears in the formulas in columns A-Q.

Can do?

Thanks a lot.

Darn, no, I only have 2010.

@FDibbins: It is basically random otherwise I could find a way around it. It is data coming out of a survey and there is no logical pattern to it.

I never imagined that something so "simple" could be such a headache...