On Wed, 4 Jun 2008 11:40:00 -0700, EarlyBirdie
wrote:

OK, thanks everyone for your responses. So since using ISLOGICAL will not
provide the desired solution, let me provide more detail to what I am
attempting to do.

Cells in column A will contain text or contain nothing. In column B's
cells, I want to have a formula that checks the adjacent column A cell to see
if its text contains any of five specified six-character strings that may be
present anywhere in the text (there will not be more than one of the values
in each cell) and then display the six-character text that may be found or
indicate that none of the searched-for strings are present. I tried some
ISERROR combinations but can't find a suitable solution.

List your desired strings in a range, and NAME the range "List" (or use the
actual cell reference).

Then try this formula to mimic your first example:

=IF(SUMPRODUCT(-ISNUMBER(FIND(List,A1)))=0,"No Claim","Claim")

Or, to display the actual code specified six-character string:

=INDEX(List,MATCH(TRUE,ISNUMBER(FIND(List,A1)),0))

entered as an **array formula** by holding down <ctrl<shift while you hit
<enter.

Formula #2 will give an error if there is no match, so perhaps, to combine the
two:

=IF(SUMPRODUCT(-ISNUMBER(FIND(List,A1)))=0,"No Claim",
INDEX(List,MATCH(TRUE,ISNUMBER(FIND(List,A1)),0)))

also entered as an **array formula**

--ron