livesmiley
New Member
- Joined
- Nov 1, 2019
- Messages
- 1
I have one file (Pay Statement) with Employee numbers (column B) and pay period dates (column E). In column M I am trying to pull in data from another file (History). The History file has the employee number (column A), the effective begin date (column C), effective end date (column D) and the chosen amount (column J). I am needing to pull the historical amount that was valid at the pay period end date for that particular employee. Any help you can provide would be greatly appreciated! Thanks!