Checkbox if 2 Criteria Met from Different Sheet

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 Smith, PMP
Assistant Director | IT Special Projects Mgr.
Oregon Parks & Recreation Department
If my response helps, please mark it as an accepted answer. 😎
Comments
-
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)
Frank Smith, PMP
Assistant Director | IT Special Projects Mgr.
Oregon Parks & Recreation Department
If my response helps, please mark it as an accepted answer. 😎
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!