Greetings,
I am trying to create a match formula that ignores partial match. For instance:
a1= to
a2= to,go,no,so
a3=top,gop,nop,sop
a4=if (not(isvalue(find($a$1, a2), true, false) ---> true
a5=if (not(isvalue(find($a$1, a3), true, false) ---> true
I would like a5 to return false. I think it is possible I just cant see the tree for the forrest.
Thanks!
Bookmarks