Hi Altair1972m,

In the "CLIENT MOVED COLUMN":
=IF(itSEARCH(A1,"move|abandoned|apartment|for rent|no one knows|vacant|
burned",,9,,,,,,0)0,1,0)

In the "CLIENT CASE CLOSED COLUMN":
=IF(itSEARCH(A1,"Closed|Post-TANF",,9,,,,,,0)0,1,0)

(etc.)


To get the itSEARCH() function, you'll need to download and install
the Free Edition of inspector text:
(it never expires, and it has all the features of the licensed
version)

http://precisioncalc.com/it


For more information on the itSEARCH function:

http://precisioncalc.com/it/itSEARCH.html



Good luck with your project!


Greg Lovern

http://PrecisionCalc.com
More Power In Excel



On Apr 20, 1:14*pm, Altair1972m
wrote:
I have a column of Vendor Comments on the Outreach effort such as

"Client's case is closed"
"Client lacks transportation"
"Client is 8 months pregnant"
"Client moved"
"House is vacant"

I want to be able tosearchwithin that column for words which will flag
other columns such as
CLIENT MOVED COLUMN
words tosearch:
"move"
"abandoned"
"apartment"
"for rent"
"no one knows"
"vacant"
"burned"
CLIENT CASE CLOSED COLUMN
"Closed"
"Post-TANF"
BARRIER REPORTED COLUMN
"Pregnant"
"Transportation"
"DV"
"Child Care"

so that these are autoflagged and so that they will have a 1 in them. *I
will then filter for column entries and then copy and paste the names of say
people who moved into another spreadsheet and send them to someone.

My friend introduced me to this phrase
=IF(SEARCH(AT$4,$Y18)0,"yes")
to try to see if I could findtextwithin another cell. *But that only works
for onetextentry. *What I am trying to do issearchmultiple phrases
withing that column and I can't get it to work.

I created the 3 columns for flagging. *I put thesearchcriteria in the next
3 columns

I tried the following 2 methods that did not work:

1)

Where Z is the FLAG FOR MOVED column, IF(SEARCH(AS$4:AS$10,$Y9)0,"yes")
curiously this one would return only a match for the first criteria unless
the two items were on the same line...let me make that one real:

If Y9 and Y10 said "Client does not live here" and AS9 said "does not live
here", the return would be 1 in Z10 but #Value! in Z11.

Whatsupwithdat?

2)

IF(SEARCH(AT$4,$Y4)0,"yes",IF(SEARCH(AT$5,$Y4)0, "yes","no"))
This one would notsearchthe nested if then.

I have about 12 criteria anyway, so could you shed any light on this?

I cannot find anything about multiple criteria in the MS Help in Excel.

The State of New Jersey thanks you for any useful input. *We use Microsoft
2003 in this office.

If this cannot be done, someone should pass this on to Microsoft, because it
has a lot of applications for future upgrades.