ExcelBanter - Combining IF statements

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Combining IF statements (https://www.excelbanter.com/excel-worksheet-functions/86957-combining-if-statements.html)

Combining IF statements

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.

Combining IF statements

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.