Hi Tony
That works a treat.
If at some point I need to change the Occupancy layout at a future date, would applying the formula =IF(ISERROR(VLOOKUP(C3,'FRONT SHEET'!$C$5:$D$25,2,FALSE)),"Empty",VLOOKUP(C3,'FR ONT SHEET'!$C$5:$D$25,2,FALSE)) and changing the cell details be sufficient.

The reason I ask is to
a) grasp what you actually did, to learn from you
b) a colleague is most likely to ask me to set the same up for the ward next door which is of a different floor plan