Hi All,
I have a problem.

I have a formula that selects the lowest connection pipe possible to two pieces of equipment. I need to extend this formula so that it will pick the lowest connection that is compatible with BOTH boxes. For instance:

box one is compatible with a b and c
box two is compatible with a b and d

The lowest connection possible works out to be d, but since this is not compatible with both boxes I need to select b.

Any help much appreciated!

Alastair