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,