Look up Three Values return true or false

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook. Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

create a hidden helper column and in it add the following (assuming your columns for ID, start and finish are A,B,C (for the purposes of this we'll assume so and that you've entered this in column D

=A1&B1&C1

Then use MATCH to check if a corresponding record exists, to search you'll need to pass the 3 values in the same way as above so lets assume you're other values are in columns AA, AB, AC

eg

Please Login or Register  to view this content.

will check rows 1 to 1000 to see if those values exist and return the row number of the 1st that does, if not then it returns 0

If you don't need to return any matching values, you could just use COUNTIFS to check for matching/duplicate entries.

Please try in D1 and copy down:

Formula:

Please Login or Register  to view this content.

Based on HansDouwe's sample workbook:

Formula:

Please Login or Register  to view this content.

copied down.

And, with O365,

Formula:

Please Login or Register  to view this content.