Forum Discussion

  • phildot's avatar
    phildot
    Copper Contributor
    Mar 23, 2020

    Hi Riny_van_Eekelen 

    One additional question: what if I want to have a second field to be checked here, e.g; to check A12 and A14?

    =IFERROR(INDEX($A$2:$A$5;MATCH($A12;B$2:B$5;0);1);"")

    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Mar 23, 2020

      phildot And what would be the result you would want to see then?

      • phildot's avatar
        phildot
        Copper Contributor
        Mar 23, 2020

        Riny_van_Eekelen 

        My problem is precisely regarding resource planning crossed tables.

        I have this origin table, filled in by the Conso team lead.

        where is for On duty and / is for absent/off duty

        I have to transpose it like this for a table that gathers several teams, where Name means "is working/present" and red means "absent"

        Your formula helps me getting the name, by using P as the matching variable, but I'd need to have the "/" variable checked as well to render another result (red box or anything else, or name with in grey/red...

         

        Not an easy one, I guess.

         

        Anyway, thanks Riny for your time.

        Phil