In sheet: B
------
Try changing the formula in K2 to:

=IF(SUMPRODUCT(--ISNUMBER(SEARCH(A!$A$1:$A$100,C2))*(A!$A$1:$A$100< ""))=1,R
OW(),"")

Copy K2 down to K100, as before

Adapt the range: A!$A$1:$A$100 in the formula to suit
(use the smallest possible range)

(No change to formulas in sheet C)

Now it should work even if you have, say:

Bill Jones 24 anytown ST
Fred Smith 56 anothertown ST
etc

instead of just the names:

Bill Jones
Fred Smith
etc

within col C in sheet: B
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"bobf" wrote in message
...
Max, I tried your download and it appears to work except for one thing.
The
column of names in the worksheet that I am trying to search is not just
names. It MAY be just names but it may also be a first name, last name,
age,
city and state, all in the same column. so now somehow I have to search
that
column and be able to filter out the rest of the information for the
search.

Hope that makes sense

Thanks again