Evaluate content based on multiple criteria.

[BillTony]

I'm trying to find "matches" (loosely speaking...) in a 3 column table and displaying the results in a 4th column. Column A is the driver, and can hold up to 5 pre-defined values, or any COMBINATION of the 5 values. Columns B and C cannot hold any of the values found in Column A, and again, can hold 1 or multiple values. I have not included any coding as I have not yet found anything that works. I'm attaching an image that should be a pretty good representation of what I wish to accomplish
ANY HELP IS GREATLY APPRECIATED!

 

[BillTony]

Well, I must say that that looks intriguing - I will certainly dive into it more closely when I am able. At this time, I have promoted the initial solution to a production environment and will be running it throughout the lifecycle of the current project.

Again, many thanks to BOTH of you for your time and effort! I cannot stress how much these solutions are appreciated!