On Mon, 11 Apr 2011 16:09:58 -0700 (PDT), kittronald wrote:

Is it possible to create a formula that looks up values in a list and
verifies whether they appear in a cell ?

For example:

A1="This is a short text entry"

B1 contains a formula that looks up multiple values elsewhere to see
if they appear in A1 and returns "True" if a match is found.

The list contains the words "This" and "entry".



- Ronald K.

If WordList represents a contiguous (no blanks) list of the words to check, then, with your data in A1:

This formula must be **array-entered**:

=OR(ISNUMBER(SEARCH(WordList,A1)))

----------------------------------------

To **array-enter** a formula, after entering
the formula into the cell or formula bar, hold down
<ctrl<shift while hitting <enter. If you did this
correctly, Excel will place braces {...} around the formula.