Forum Discussion
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...
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.
Worked Perfectly, thanks so much.