Forum Discussion

George Weimann's avatar
George Weimann
Copper Contributor
Dec 28, 2017

Matching columns with rows

Trying to create a formula that will return the text "RDO" when the column day matches the specific day off in column G or H for this particular employee on the day in question. 

 

In other words, when its the employees day off, I want that specific date blocked out with RDO in it.  Does anyone have a specific formula that would do that.  I researched MATCH, INDEX, and other formulas, but just don't understand it enough to figure it out on my own.

 

Thanks,

 

 

excel
  • Deleted's avatar
    Deleted
    Dec 28, 2017

    Hello George Weimann,

     

    - Use the below formula in cell - I4:

    =IF(OR($G4=I$2, $H4=I$2),"RDO", "")

    - Then drag/copy&paste the formula until you need it.

     

    Hope that helps..!!

     

    Thanks,

    Bala..

     

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Dec 28, 2017

    George,

     

    You don't need to INDEX or MATCH, you just need this formula:

     

    =IF(OR($G4=I$2, RIGHT($H4,3)=I$2,LEFT($H4,3)=I$2),"RDO", "")

    Actually, I've updated the formula in the previous answer to take into account this situation:

     

    SAT SAT - SUN

     

    Please find the attachment file.

Resources