Looking for a number in a cell of a range and returning other cells values

I am trying to make an schedule for my group. I want to know who is going to be working by knowing the days each member is going to be off   Something like this:   Formula located on E4 ret...