Skip to main content

I’m looking for a way to pull the matching record in two fields.


I’m pulling a bill of materials in from our product table so for example it will pull in these records;

8" Black rod

6" Black Shade

10" Box


In another field I’m pulling in all the parts that match a certain attribute for example

6" Red Shade

10" Red Shade

6" Black Shade

10" Black Shade

6" Green Shade

10" Green Shade


I’m trying to create a field that will see that in the example above the 6" black shade is in both of those fields and return that record.

Hi @Michael_Harrison,


Just to understand better, both will be in the same record (row)?


If so, you can make a formula in a new field that is something like IF(field1=field2, Field1, 0)


Reply