or(exact)) function does not work

F

Fustrated user

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.....
 
Top