Hoping this is possible.
In B I have a list of papers
In X there is an IF(AND formula which tells me whether a product type (EU) is suitable for the paper or not.
Where there are multiple papers, I'm seeing multiple EU's - I only want one, however.
<tbody>
B
V
W
X
Preferred X Result...