Combining IF statements

[Guest]

I need to combine multiple IF statements such as

=IF("Debbie"=Kim!B4:H18,"Kim","")
=IF("Debbie"=Bob!B4:H18,"Bob","")
=IF("Debbie"=Joe!B4:H18,"Joe","")

or an easier "statement" to use? I have roughly 15 of these I need to
combine.

 

[Don Guillett]

What are you trying to do?

 

[Guest]

It is a schedule of sorts. I am trying to make it auto fill a second set of
worksheets whenever I fill out the 1st set of sheets.
Exp. If I put Debbie in box C4in "Kims" worksheet, I want it to fill in
"Debbies" worksheet box C4 with the name Kim.
This equation does that, but only works for 1 worksheet.
=IF("Debbie"=Kim!B4:H18,"Kim","")
There are about 15 people on each side of this equation.