cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Excel Error with Find() and array

Randy Thorderson
Copper Contributor

‎Jul 21 2018 07:39 AM - last edited on ‎Feb 01 2023 10:14 AM by

‎Jul 21 2018 07:39 AM - last edited on ‎Feb 01 2023 10:14 AM by

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

Labels:
558 Views
0 Likes
0 Replies
Reply
0 Replies