Hello,
Kindly help, is there an alternative to the 'if' and 'contain' function? I can't manually build it using the 'if' because I have 50 persons to be matched to 200 lines of data with different kinds of description.
Eg, I have these names:
Isaac Newton
Louis Pasteur
Nikola Tesla
and I have a list data of that which I want to match:
1) Inv123456 Newton
2) Housing Louis Jan13
3) Isaac flight
Is there a formula that will give me these answers:
1) Isaac Newton
2) Louis Pasteur
3) Isaac Newton
Your help is greatly appreciated!
Regards,
Bookmarks