Cliff, I don't know what you're trying to accomplish.

You've changed your problem statement 3 times.

Provide a succinct description along with a

sample data set and desired results.

Sorry, I'll try to explain better. I need for one formula to do this: check cell h32, if it contains 10:00 or 11:00 then produce the name Cliff, if not then check cell h33, if that one contains 10:00 or 11:00 then produce the name Jamie, if that one doesn't, then check cell h34, if it contains 10:00 or 11:00 then produce the name Adam, if that one is false, then check cell h35, if it contains 10:00 or 11:00 then produce the name Fonda, if it doesn't then check cell h36, if it contains 10:00 or 11:00 then produce the name Kerwin, if none of the cells contain 8:00 or 10:00 then leave blank. So, I am trying to find the correct way to write the following formula: =if(h32=10:00, 11:00), "Cliff", if not then does (h33=10:00, 11:00), "Jamie", if not then does (h34=10:00, 11:00), "Adam", if not then does (h35=10:00, 11:00), "Fonda", if not then does (h36=10:00, 11:00), "Kerwin", if not then leave blank. I hope this explains it better.

{=CHOOSE(MIN(IF((($H$32:$H$36=10/24)+($H$32:$H$36=11/24)),{1;2;3;4;5}))+1,"","Cliff","Jamie","Adam","Fonda","Kerwin")}

Note: This is an array formula which must be

entered using the Control+Shift+Enter key

combination. The outermost braces, {}, are not

entered by you -- they're supplied by Excel in

recognition of a properly entered array formula.

Went a little bonkers with parentheses...

...you can shed a pair...

{=CHOOSE(MIN(IF(($H$32:$H$36=10/24)+($H$32:$H$36=11/24),{1;2;3;4;5}))+1,"","Cliff","Jamie","Adam","Fonda","Kerwin")}

{=CHOOSE(MAX(($H$32:$H$36=10/24)+($H$32:$H$36=11/24)*{5;4;3;2;1})+1,"","Kerwin","Fonda","Adam","Jamie","Cliff")}

...which eliminates the need for IF.