You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"DoubleZ" wrote in message
...
Fantastic. Thank you.

"T. Valko" wrote:

One way:

=COUNTIF(A1:A10,B10)0

--
Biff
Microsoft Excel MVP


"DoubleZ" wrote in message
...
In Excel 2007, i need to search for a certain word within an array.
For
example, I have array A1:A10. Each cell in this array contains a word.
In
Cell B10 I have a word. If the word in B10 is the same as any of the
words
in the array then I need then I need an IF statement to return true.
If
it
is not contained in the array, I need it to return false. As far as I
know,
the Search function online applies to searching for a certain value
within
one cell, not multiple cells.

Thanks for any help,
DoubleZ