or(exact)) function does not work
 

Help!

I am trying to compare a list of words to an array of words.

so example:
john to great
dog
john

To do this I am using the function
=or(exact(A1, B1:B3))

As told to do by help... but this does not work if the word you are
searching for is not the first cell in the array.....

Please help on why this is.....

or(exact)) function does not work
 

Hi
enter this as array formula (with CTRL+sHIFT+ENTER)

-----Original Message-----
Help!

I am trying to compare a list of words to an array of
words.

so example:
john to great
dog
john

To do this I am using the function
=or(exact(A1, B1:B3))

As told to do by help... but this does not work if the
word you are
searching for is not the first cell in the array.....

Please help on why this is.....


.