Global Industrial Price Update

Job ID: 30716331

Budget: $15 – $25 USD

I need help matching cells then entering info based on the match. I have uploaded 2 files.
1. Global Industrial 070121
2. Leadpricetemplate

I need new cost from Global Industrial 070121 to be copied into Leadpricetemplate column I New Cost based on Part #. I also need MAP from Global Industrial to be copied into Ledpricetemplate column J MAP. Not all parts from Global Industrial will be on Leadpricetemplate. I also need to see formula.
Related categories: Excel Mathematics