How to handle in case where we have 1 option as a string subset of another, i.e. 1 option in multi-select is John and other option are Johnny, JohnnyR. If I use above formula and want to print something when I see only 'John', the find doesn't work. ...
I have exact same issue. However, in my case, the 'Article' link can have multiple values and the lookups can be repetitive. For example, row no. 1 can have 'Recreation' and 'Paloma' as 2 linked fields; then both these fields will have their lookups ...