Dear all,
I've been scanning for a few hours now but can't find a solution. I've got a column with words of a group of words. Like: A2: "conflicts of interest" A3: "regulations".
Then I've got a cell that contains text like: B1 "the regulations for conflicts of interest within this firm are the following bla bla bla"
Now I would like to assign a value of to for instance B2 if B1 contains the exact content of A2. Then I would like to expand this formula keeping B1 as a resource.
Can anyone help me out?
Bookmarks