Matching data from one table into the other

Hey, Match data from one table into the other. I have a list of reference numbers, old and new. I have one table called PIMI mapping that references the new numbers with the old numbers. And another table that contains the old numbers that came from our old system. Here is what PIMI mapping looks like

PIMI MI
E0210 002 DIN-MI-137
E0301 001 DIN-MI-0501
E0301 002 DIN-MI-0503
E0302 001 DIN-MI-0302

here is the other table -

IDKEY JPNUM IDOWNERTABLE PIMI'S FROM JOBPLANS REPLACEMENT MI
759 RCF00001 JOBPLAN E0301 024
1085 GM00091 JOBPLAN E0301 022
1735 YO0008 JOBPLAN E6702 025
1035 DTV006 JOBPLAN E6702 025

I would like to read the value on the other table, then find it in the PIMI mapping table(top table), then get the MI number from that and put it into the REPLACEMENT MI Colum in the other table (bottom table). Is this possible?
Thanks.

your tables are not understandable...
so provide an sample non sensitive workbook..
with expected result..

Don't forget to click *

Hi,

Is this what u r trying to find map ?
If not update a sample workbook with out any confidential data showing before and after sheets.

Punnam