Combining IF statements

[Macmo]

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?

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Macmo" <Macmo@discussions.microsoft.com> wrote in message
news:40CAB84B-6FFE-4392-B890-A36C111E9EA5@microsoft.com...
>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.
>

[Macmo]

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
> dguillett1@austin.rr.com
> "Macmo" <Macmo@discussions.microsoft.com> wrote in message
> news:40CAB84B-6FFE-4392-B890-A36C111E9EA5@microsoft.com...
> >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.
> >
>
>
>