Hi there, I hope someone can help me as I've become a bit desperate!!
Im trying to create a rota, which updates a new persons name every wednesday, as the rota changes. So far so good, but I want to create a cross check of our holida roster, so that if the person is on holiday when their name appears, a warning is triggered.
So far I have a simple lookup which looks up the date and the persons name next to it.
So our holiday rota looks like this, where the numbers are days of the month, and an H means a holiday.:
A B C D
1 NAME 1 2 3
2 PERSON A
3 PERSON B H
4 PERSON C
So what I want is a formula that says if today is day 2 (col. c) is todays person off on holiday? Therefore, if todays name is person B and today is day 2, are they here??
I feel like this is very basic formula but I can't get it right!!
Please help if you can!
Bookmarks