software

Hi,

I'm trying to create an if statement, with no luck.

Col A Col B Col F
Apples value nanas
Bannanas wackos
Coconuts value

Formulas in Col B:
If any of the text in Col A matches another cell with quot;nanasquot; or quot;wackosquot; in
it (in this case F1 and F2), then leave the cell blank, otherwise X. X being
another formula that returns some random value.

Essentially I'm trying to create a reference list in column F, for as many
references as possible, maybe up to 20, so if any of the values in col A
match any of the text strings in column F, it leaves the cell blank.

I tried, couldn't do it. Saw something with =Countif(A1,quot;*nanas*quot;) but
couldn't adjust it.

Thanks very much.

Hi!

Try this:

=IF(SUMPRODUCT(--(ISNUMBER(SEARCH(F$1:F$2,A1)))),quot;quot;,your_other_form ula_here)

Copy down as needed.

Biff

quot;SteveCquot; gt; wrote in message
...
gt; Hi,
gt;
gt; I'm trying to create an if statement, with no luck.
gt;
gt; Col A Col B Col F
gt; Apples value nanas
gt; Bannanas wackos
gt; Coconuts value
gt;
gt; Formulas in Col B:
gt; If any of the text in Col A matches another cell with quot;nanasquot; or quot;wackosquot;
gt; in
gt; it (in this case F1 and F2), then leave the cell blank, otherwise X. X
gt; being
gt; another formula that returns some random value.
gt;
gt; Essentially I'm trying to create a reference list in column F, for as many
gt; references as possible, maybe up to 20, so if any of the values in col A
gt; match any of the text strings in column F, it leaves the cell blank.
gt;
gt; I tried, couldn't do it. Saw something with =Countif(A1,quot;*nanas*quot;) but
gt; couldn't adjust it.
gt;
gt; Thanks very much.
Super! How do you guys come up with this stuff? I never would have thought
of that. Thanks so much.
You're welcome. Thanks for the feedback!

gt;How do you guys come up with this stuff?

It's the challenge of problem solving! Believe it or not, it's fun!

Biff

quot;SteveCquot; gt; wrote in message
...
gt; Super! How do you guys come up with this stuff? I never would have
gt; thought
gt; of that. Thanks so much.
gt;
gt;