I would like to write an IF statement that would put an asterick in a
specific column of the same row where any text residing in Column A matches
specific text.

Example:

Column A of Row 125 contains the text "top rated auto insurance". I would
like for the IF statement to test for the word "insurance" and place an
asterick in Cell I125.

Thanks!

In I125 put

=IF(ISERROR(SEARCH("insurance",A125,1)),"","*")

copy throughout column I as needed.

"cynichromantique" wrote:

I would like to write an IF statement that would put an asterick in a
specific column of the same row where any text residing in Column A matches
specific text.

Example:

Column A of Row 125 contains the text "top rated auto insurance". I would
like for the IF statement to test for the word "insurance" and place an
asterick in Cell I125.

Thanks!

JMB,

Is it possible to add additional words to a statement of this nature?

Examples:

coverage
homeowners
annuity
blue cross
group

Thanks!

cynichromantique

"JMB" wrote:

In I125 put

=IF(ISERROR(SEARCH("insurance",A125,1)),"","*")

copy throughout column I as needed.

"cynichromantique" wrote:

I would like to write an IF statement that would put an asterick in a
specific column of the same row where any text residing in Column A matches
specific text.

Example:

Column A of Row 125 contains the text "top rated auto insurance". I would
like for the IF statement to test for the word "insurance" and place an
asterick in Cell I125.

Thanks!

So if A125 contains any of those words, return an "*"?

IF(SUMPRODUCT(--ISNUMBER(SEARCH({"insurance","coverage","homeowner s","annuity","blue cross","group"},A125,1))),"*","")



"cynichromantique" wrote:

JMB,

Is it possible to add additional words to a statement of this nature?

Examples:

coverage
homeowners
annuity
blue cross
group

Thanks!

cynichromantique

"JMB" wrote:

In I125 put

=IF(ISERROR(SEARCH("insurance",A125,1)),"","*")

copy throughout column I as needed.

"cynichromantique" wrote:

I would like to write an IF statement that would put an asterick in a
specific column of the same row where any text residing in Column A matches
specific text.

Example:

Column A of Row 125 contains the text "top rated auto insurance". I would
like for the IF statement to test for the word "insurance" and place an
asterick in Cell I125.

Thanks!

Or use OR <g

=IF(OR(ISNUMBER(SEARCH({"insurance","coverage","ho meowners","annuity","blue
cross","group"},A125,1))),"*","")


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"JMB" wrote in message
...
So if A125 contains any of those words, return an "*"?

IF(SUMPRODUCT(--ISNUMBER(SEARCH({"insurance","coverage","homeowner s","annuity","blue
cross","group"},A125,1))),"*","")



"cynichromantique" wrote:

JMB,

Is it possible to add additional words to a statement of this nature?

Examples:

coverage
homeowners
annuity
blue cross
group

Thanks!

cynichromantique

"JMB" wrote:

In I125 put

=IF(ISERROR(SEARCH("insurance",A125,1)),"","*")

copy throughout column I as needed.

"cynichromantique" wrote:

I would like to write an IF statement that would put an asterick in a
specific column of the same row where any text residing in Column A
matches
specific text.

Example:

Column A of Row 125 contains the text "top rated auto insurance". I
would
like for the IF statement to test for the word "insurance" and place
an
asterick in Cell I125.

Thanks!

Perhaps just

=IF(COUNT(SEARCH({"insurance","coverage","homeowne rs","annuity","blue
cross","group"},A125)),"*","")


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=528396