Formula help please
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
|