Excel Error with Find() and array

Highlighted
Occasional Visitor

I give up...why does this formula not work (#VALUE!) when A1 =  WA ?

=FIND({"OR","WA"},A1)

 

It works fine when A1 = OR

0 Replies