Combining two lookup functions?

I'm not sure how to articulate this, or what formula I need to use but i'm thinking lookup? I need to find the effective date for the employee's current position, so, in this example, for ID 1, I ne...

excel

Formulas and Functions

Alan_Murray
May 13, 2020
Joannerw
Here is an updated solution which I believes answers the question.
It is an array formula so you need to press Ctrl + Shift + Enter to run it on your Excel version.
query.xlsx10 KB