Help writing an IF statement
 

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!

Help writing an IF statement
 

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!

Help writing an IF statement
 

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!

Help writing an IF statement
 

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!

Help writing an IF statement
 

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!

Help writing an IF statement
 

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

Help writing an IF statement
 

good call <g

"daddylonglegs" wrote:


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