I have set up a Rota for various staff within Excel there
is a worksheet for each department. I also have a
Holiday Sheet set up so if you enter H in any cell on the
Rota it will automatically transfer to Holiday sheet. I
have done this using the IF function.

I now want to extend this to Using S for Sickness M for
maternity etc but if i try using multiple entries of IF
function i just keep getting error.


Any Suggestions?