Search for a string within a field and return another field as a reference.

[9917mark]

Morning, the name is Mark

Could I ask for assistance on the following challenge please.

I am trying to map a business product file to a supplier's product file.

My product description contains reference to the suppliers product code within my description. I need to retrieve my corresponding product code.

Below is my supplier product file :

Below is my product file :

What I need to do is search for the Supplier Code (As on invoice) in the supplier product file, within New Description in my product file.

In other words I need PARTNO 1007860 to be returned when i search for TC322234 within my New Description

This information needs to be captured in a field on my product file.

Your help in this matter is appreciated,

Regards,

Mark

[9917mark]

Thanks for all your help and patience, to all the other member who have posted replies and comments thanks for taking the time to help me out. It is appreciated. SasiParupudi1‌ thanks for your input, I have found your reply intresting and am busy working through your suggestions.