Excel 2007 : Multiple IF + VLOOKUP filling data on multiple criterias

Hi guys, good day.

Need some advice on the formulas which i worked out on my spreadsheet.

I am doing some schedule fixing for "staff on duty", 3 personnel at the moments.

Here's my issues:

Question 1)
If A=1, then A, else look for B=1, then B, else look for C=1, then C, if none of these met the criteria then NIL. But what i got back is FALSE (cell K7 as per attached file). Anyone can enlighten what mistake did i made?

Question 2)
Is there any shorter or better solution to what i am formulating now?

Question 3)
If additional personnel D & E arises, do i continue with my IF formulas?

Question 4)
Earlier assumption was made on 0=Off Day, 1=Word Day but what if the situation change to
0=Off Day, 1=Half Day, 2=Full Day, I have no clue on what should i do next, need your valuable input.

Please find the attached spreadsheet as below.


Thank you in advance.

arh right! thanks JB, i really missed that.

JB, do u have any other suggestion/alternative function which I could use to formulate?

I am just worries over that the more IF i do, the more mistake i will make.

Many thanks.