Finding the intersection

[sjb90]

Hello, I need to find an intersection of two values on a table and then add it as a new column to a separate data sheet. I have created a dummy data sheet as the one I am working on is official; but for example where Table is black. I can't work this out and would appreciate the help. 

[alexnajm]

I’m not sure I understand - what is the expected output in this case? What defines an “intersection”? 

[Raj]

@sjb90 you need to add the required output as well or the logic you want to apply.

[sjb90]

Sorry for the confusion. I need to find a particular cell in the table and add this onto the table in a new column. So for example on the example I attached, if I needed to find the intersection of how many black tables there are and add that number to a new column which tool would I need to do that.  

[aatalai]

@sjb90 not 100% sure what you asked for but did what I think you wanted via a macro and put it in a workflow as an example, please let me know if this is what you were looking for?

[OTrieger]

@sjb90 

How the criteria is been selected for the intersection?

There is a way to get data matched however you will need to define what are the variables for the match. So what @alexnajm and @Raj trying to understand is what the logic and condition for it.