formula that satisfies two conditions and search the name

[jpgmaas]

Hello I have already asked about this problem, but I want to do it differently. see my example agenda3e.xls.
http://www.excelforum.com/excel-form...other-tab.html
it helped me well on the way, but I want some more and easier with pul down menu, nurses must be working with it and they have not a lot off time.

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

Jean-Paul