View Single Post
 
Old 12-07-2017, 07:07 AM
KDP KDP is offline Windows 10 Office 2016
Novice
 
Join Date: Nov 2017
Posts: 13
KDP is on a distinguished road
Default 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
Reply With Quote