Finding the intersection

Question

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.

DummyData.xlsx

OTrieger · Answer

@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.

aatalai · Answer

@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?

Finding the intersection.zip

sjb90 · Answer

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.