hopefully someone can help me, i have tried a few different array formulas, but nothing seems to get exactly what i need.
i need to match a certain word from column a with its matching word (can occur multiple times) in column i with the adjacent word in column j.
i have not been able to do this accurately.
can anyone help?
thanks in advance.
Bookmarks