Formula to populate cell based on data input elsewhere

Help please. I need to track a number of people as to whether they are present or not. I input data on one sheet which tells me whether or not they are present but I need the information to flow to another sheet.
If a person is listed in 1 place I need them to be shown in hospital, in a 2nd place they need to be shown on vacation, otherwise I need to be able to see special comments for them if any are appropriate. Currently I am using IF & IF in the same formula but it does not allow me to eliminate the special comment properly.
Here is a copy of the ugliness I am currently using:

IF(OR(Daily!$E$8=C32,Daily!$E$9=C32,Daily!$E$10=C32,Daily!$E$11=C32,Daily!$E$12=C32,Daily!$E$13=C32,Daily!$E$14=C32),"Hospital","Diabetic")&IF(OR(Daily!$B$46=C32,Daily!$B$47=C32,Daily!$B$48=C32,Daily!$B$49=C32,Daily!$B$50=C32,Daily!$B$51=C32,Daily!$B$58=C32,Daily!$B$52=C32,Daily!$B$53=C32,Daily!$B$54=C32,Daily!$B$55=C32,Daily!$B$56=C32,Daily!$B$57=C32),"Away","")

In this case C32 is the reference to that particular person.
Any suggestions?

Thanx

Oh my, do I feel silly. I tried something simple and solved it myself. Thanks anyhow.