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.

What are you trying to do?

--
Don Guillett
SalesAid Software

"Macmo" wrote in message
...
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.

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.

"Don Guillett" wrote:

What are you trying to do?

--
Don Guillett
SalesAid Software

"Macmo" wrote in message
...
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.