Forum Discussion
Randy Thorderson
Jul 21, 2018Copper Contributor
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
I give up...why does this formula not work (#VALUE!) when A1 = WA ?
=FIND({"OR","WA"},A1)
It works fine when A1 = OR