I need help with a formula.

Dakota

I have 2 sheets. Both sheets have dates and names. I need to compare the names, if both match then I need to compare dates, if they match I need to return a 1 to check a box. How do I go about writing this?

Bassam Khalil

Hi @Dakota

please try the following formula:

=IFERROR(IF(OR([Name 1]@row = "", [Date 1]@row = ""), 0, IF(COUNTIFS({Name 2},
@cell = [Name 1]@row, {Date 2}, @cell = [Date 1]@row) > 0, 1)), "")

the following screenshot shows the result:

Main Sheet

Second Sheet:

Bassam Khalil

Hi @Dakota

please try the following formula:

=IFERROR(IF(OR([Name 1]@row = "", [Date 1]@row = ""), 0, IF(COUNTIFS({Name 2},
@cell = [Name 1]@row, {Date 2}, @cell = [Date 1]@row) > 0, 1)), "")

the following screenshot shows the result:

Main Sheet

Second Sheet:

Dakota

Thank you,

After adding a reference sheet it worked perfectly.

Thank you,

Bassam Khalil

@Dakota

Excellent, I will be happy to help you any time