Return True or False for set range of criteria

[Melchizedek]

Hello all and thanks for taking the time to help

I am looking for a formula to give me a "1" or "0" when something has been posted on a date.

In cell m4 "Weekly plan" I would like to check if cell c4 & d4 have a matching "stop date" to m3 in shop floor clockings sheet and return a 1 or 0 based on if there is a match.

Please let me know if further explanation is required

[AliGW]

You have not given us any manually mocked up results to show what you want to achieve, as far as I can see. Please do so and post the file again.

[Melchizedek]

I have updated the attachment to show where there should be "0" and "1".

[José Augusto]

Hi

Try this formula in M4 and drag down and forward

Please Login or Register  to view this content.

[Melchizedek]

Jose, thank you for your help.

[José Augusto]

You are welcome.

Thanks for the rep and feedback.

[Melchizedek]

Hello José, I tried loading this onto my sheet with over 3000 lines and it seems to be struggling with the calculation. Have you any ideas on how to speed this up or get the same result with a lite version?

[José Augusto]

Hi

Try this solution:
1) Helper column in 'Shop Floor Clockings'!BM2 (drag down)

Please Login or Register  to view this content.

2) In 'Weekly Plan'!M3 (drag forward)

Please Login or Register  to view this content.

3) In 'Weekly Plan'!M4 (drag down and forward)

Please Login or Register  to view this content.

Note: I suppose 'Shop Floor Clockings'!BM is a empty column

See the file