Okay I have a bit of a doozy. I need to pull in the cost center one sheet onto another sheet. The trick is that it needs to be the closest date to the effective date without going over AND it needs to be the highest sequence number.
I've attached a test worksheet. The EE tab needs to pull in the cost center from the Job tab. I've input the expected result in the cost center column on the EE tab.
I think the key is going to be something like this. I'm just not sure how to work it all out with the sequences.
Bookmarks