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.