Forum Discussion
Solved
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...
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.
Please find the attached workbook with a solution.
I used the following formulas in a table to get the results for all the IDs
=INDEX(C:C,MATCH(G3,B:B,0)+COUNTIF(B:B,G3)-1)
Alan
Hi Alan_Murray . Thank you for your help. The query works great, but we can have several staff with the same Position Code so it isn't working for my data.
