It's not real clear what you want to do. Here's my best guess...

Assume you want to know if John is in the range.

=IF(COUNTIF(A1:A100,"John"),"John","not found")

Better to use a cell to hold the criteria:

C1 = John

=IF(COUNTIF(A1:A100,C1),C1,"not found")

--
Biff
Microsoft Excel MVP


"JOHN" wrote in message
...
I am using Excel 2007, I have a column containing formulas that would
return
a name if true and a zero if false. I want to search the column for the
text
entry and return that text as the answer. Can I do this or should the
column
formulas be changed to something else? The "T" formula seems to work only
for one cell not the whole column.