formula that satisfies two conditions and search the name on the other tab.

I can hard to describe in English, but maybe you can see more in the atachmend. What I want is that if a2 is true and c5 is true that the name of the resident upon move. If Ms. weet1 member of testa1 and a2 is one room then put it on the list. WHEN a2 changed in 2 than the occupants of room 2. etc. I later make a userform to fill. the weekly calendar But I did not while the search formula needed and can not get out. Or it may be better with a macro?

I volunteer for a nursing home for people with dementia. I have made ​​a whole database created with excel, so that the administration is easier. This is a new part of it.

Hope you can help me Jean-Paul