HELP--Text Formulas!

[luxe]

I am DESPERATELY trying to write a text formula that will do the
following:

Let's just say there are 2 columns, A ,B,C,D

I need column A to read YES (or any other differentiating reference) if
any row in Column B contains the word "veritas"

The text in Column B is consisted of extremely long URLs and they are
all different so I can't use a differentiator or numbers of letters to
the right

Is this possible?!?!?!

 

[Peo Sjoblom]

Assuming you want the yes in A in the same row where it found it in B?
in let's say A2 put

=IF(ISNUMBER(SEARCH("veritas",B2)),"YES","")

copy down

 

[Dave R.]

Let's just say there are 2 columns, A ,B,C,D

How about A and B

I need column A to read YES (or any other differentiating reference) if
any row in Column B contains the word "veritas"

When you say you want *column* A to read "YES" if ANY row in column B, do
you mean you want to duplicate the same formula on each row of that column
(1), or do you mean you want the formula cell at column A in row 2 to show
you whether the corresponding column B contains "veritas" (2)?

It makes more sense to do the latter, but everyone's different.

The text in Column B is consisted of extremely long URLs and they are
all different so I can't use a differentiator or numbers of letters to
the right

Is this possible?!?!?!

You can try:
(1) - in A1, put: =IF(COUNTIF(B$1:B$9999,"*veritas*"),"Yes","")

This will read "Yes" when any cell from b1:b9999 contains "veritas", whether
1 says "veritas" or 9500 say "veritas".

(2) in A1, put: =IF(COUNTIF(B1,"*veritas*"),"Yes","")
then copy it down as many rows as you have. this will show you when the data
in column B of whatever row the formula is in (as long as copied so the
reference will change) contains 'veritas'.