M Code to extract IO number

hi there

I have a list of Machinery Items with Internal order (IO) Numbers. 

I then have a list of transactions with the IO number contained in it. 

I would like to write some sort of M code which attempts to do the following:

1) Extracts the IO numbers from the machinery list

2) If one of these IO numbers is found in the transaction list, add the IO as a custom column

3) If no IO is found, return BLANK. 

Sample Machinary list:

Sample transaction list

The goal is to create a list of machinary items that has a relationship with the transaction table via a new column called IO number. 

Thanks