Hello:



I need help with a formula. In one sheet i have employee and their specific job code and their country location. On another sheet I have specific job code, country location and pay. How can i bring this over to my first sheet to make it employee specific.

1 sheets columns: Emp IS, Emp Name, JOb Code, Country
2nd Sheet Columns: Country, Job Code and Base Pay

I need my 1st sheet to look like:

Emp Id Emp Name Job Code Country Base Pay
123 XYZ 2415 Argentina 50,000
4812 MNO 2415 Canada 90,000


Any help would be greatly appreciated. Thank you
KDP