Shortcut to using many or conditions?

I have a dataset where I need to see if a particular row contains 4 conditions, like the following:

2/1/2016 EB 112 D13A
2/1/2016 EB 112 D24A
2/1/2016 EB 112 F24A
2/1/2016 EB 112 F24B
2/1/2016 EB 112 H13A
2/1/2016 EB 112 H24A
2/1/2016 EB 122 B13A
2/1/2016 EB 122 D24A
2/1/2016 EB 122 D24B
6/1/2016 EB 112 2C0A
6/1/2016 EB 112 6C0A

So if a row in my data contains a certain date, a certain two letter code, a certain three digit number, and a certain 4 digit code, I indicate "yes" or "no. I think I can do this with IF, AND, and OR together, or use MATCH with 4 conditions per row, but I have 50 rows of 4 conditions. Is there an easier way? Thank you.

Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

I have attached a sample with the condition rows in the lower right side. Thank you.

If I understand correctly ....

in P14

=L14&M14&N14&O14

copy down

in I2

=IFERROR(IF(MATCH(A2&C2&D2&F2,$P$14:$P$68,0),"Yes"),"No")

Originally Posted by JohnTopley

If I understand correctly ....

in P14

=L14&M14&N14&O14

copy down

in I2

=IFERROR(IF(MATCH(A2&C2&D2&F2,$P$14:$P$68,0),"Yes"),"No")

Thank you, that worked! I apologize for bothering you for such a simple problem.

No problem: glad it is solved.