Forum Discussion

Randy Thorderson's avatar
Randy Thorderson
Copper Contributor
Jul 21, 2018

Excel Error with Find() and array

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

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

 

It works fine when A1 = OR

No RepliesBe the first to reply