Hi Steve
In that case the solution I gave you will still work. However, for example, if Mary is in Room 2 and you change James to Room 2 on row 10 it will only pick up the first occupant of Room 2 which may not be correct.
hope this makes sense.
If you need any further help I would be glad to help.
Good luck.
Tony