Find formula for two tables

1

I have a table with a list of equipment and information for each piece. I have a second table with a current list of equipment that was done by an outside vendor so the information is not exactly the same. I am looking for a formula which will check serial numbers in table a against the serial numbers in table b and if they do not show up, make the cell red. I have looked and cannot find a way to do this so I thought I would ask here. Thanks for any help you can provide.

2

Hey there!

Would this thread help out?

If not, feel free to share the document or a little more context and a ton of people in the community would be willing to help out

3

I managed to get it to work with this

If(thisRow.[Serial #].Contains([Master Equipment List 2.0].[Serial Number]),“YES” ,’’ )

And then used conditional formatting to turn the cell red.

Thanks for the reply!

4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.