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...
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..