Forum Discussion

Joannerw's avatar
Joannerw
Copper Contributor
May 13, 2020
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...
excel
Formulas and Functions
  • Alan_Murray's avatar
    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.

Joannerw's avatar
Joannerw
Copper Contributor
May 13, 2020

Hi ShishirKumar . Thank you for your help. However, a number of employees can have the same position code, so this method isn't working for my data.

ShishirKumar's avatar
ShishirKumar
Brass Contributor
May 14, 2020

HiJoannerw 

Though same position code is there for employees but date is different for a combination of Id and position code. I guess sorting and then VLOOKUP can solve your problem.

  • Joannerw's avatar
    Joannerw
    Copper Contributor
    May 14, 2020

    Thanks for your suggestion. I've had a response which worked.

Resources