Search Value in List of Values

Ben,

Index creates an array of values, in this case True/False for each comparison of cells A1:A3 to B2. So if A2 actually is equal to B2, then it would create an array of {FALSE,TRUE,FALSE}
The OR function looks for any instances of TRUE and if it finds any, then the OR function returns TRUE, so in this example it would return TRUE because A2=B2. Only if there are no TRUE values at all will the OR function return FALSE.

That all being said, there is no reason to use OR(INDEX over COUNTIF for this task.

You're very welcome

If that takes care of your need, please mark this thread as solved.
How to mark a thread Solved
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
Go to the first post
Click edit
Click Go Advanced
Just below the word "Title" you will see a dropdown with the words "No prefix"
Change to "Solved"
Click Save

"wadekranz",

Welcome to the forum!
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.