Checkbox if 2 Criteria Met from Different Sheet

Frank S.

What am I missing:

I have a date and time from a master sheet, if both match want the checkbox in a second sheet

I can get the the formula to work if separate but when I tray and combine they do not work

Date Check Formula: check box works

=IFERROR(IF(INDEX({Test Range 2}, MATCH(Date@row, {Test Range 2}, 0)) <> "", 1, 0), 0)

Time Check Formula: check box works

=IFERROR(IF(INDEX({Test Range 3}, MATCH(Time1, {Test Range 3}, 0)) <> "", 1, 0), 0

When I combine the checkbox is not checked and should be:

=IFERROR(IF(INDEX({Test Range 2}, MATCH(Date@row, {Test Range 2}, 0)), IF(INDEX(Test Range 3}, MATCH(Time1, {Test Range 3}, 0)) <> "", 1, 0)), 0)

Should I be using AND, if so, any help on how to combine them?

Frank S.

Found a Solution! :)

Here is the formula I was able to get to work:

=IFERROR(IF(AND(INDEX({Test Range 2}, MATCH(Date@row, {Test Range 2}, 0)) <> "", INDEX(Test Range 3}, MATCH([Meeting Time (8-10)]@row, {Test Range 3}, 0)) <> ""), 1, 0), 0)