Yep, that`s the one Jacob.
Thanks for the corection

"Jacob Skaria" wrote:

'correction

=IF(ISNUMBER(MATCH(J3,{"Mon","Tues","Wed","Thurs", "Fri"},0)),
IF(H3="Mr D","12-1pm",IF(H3="Mr O","7.45-8.45am","")),"")

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Try the below

=IF(ISNUMBER(MATCH(J3,{"Mon","Tues","Wed","Thurs", "Fri"})),
IF(H3="Mr D","12-1pm",IF(H3="Mr O","7.45-8.45am","")),"")

If this post helps click Yes
---------------
Jacob Skaria


"Romileyrunner1" wrote:

Hi,
I want to do something on the lines of ....

=IF(H3="Mr D", AND IF(J3={"Mon", "Tues", "Wed","Thurs","Fri"},12-1pm),IF
(H3="Mr O, AND IF(J3={"Mon", "Tues", "Wed","Thurs","Fri"}7.45-8.45am)

If that makes any sense to anybody AND IF ANYONE CAN SORT IT OUT, I would be
very grateful.
Thanks folks.
RR1