Multiple unique search returns

[RussellPatterson]

Hi I am using the below formula to find unique values in column KK if Column D:D = B3.

=LET(f,UNIQUE(FILTER('CEV - BRM View'!K:K,(ISNUMBER(SEARCH(B3,'CEV - BRM View'!D:D))))),TEXTJOIN(CHAR(10),TRUE,IF(f="","Blank",f)))

What I want to do is the same, find unique values in KK if column D:D = B3 and column O:O = F1

Can anyone help me?

[#2]

@RussellPatterson 

What you've shared is a relatively complex formula. Speaking just for myself, I would find it easier to be confident of any suggestion I might have if I could test it first with the actual spreadsheet (or a reasonable mockup, if the actual contains confidential info).

You may be able to post such a copy on a reply to this message, assuming you see something like the following at the bottom of the message box.

If not, put a copy on OneDrive or GoogleDrive and paste a link here that grants access to it,

[#3]

@RussellPatterson 

If I understand your arrangement correctly, you could use:

My formula uses named items.

=LET(
    line_break, CHAR(10),
    crit, (Col_D = B3) * (Col_O = F1),
    distinct, UNIQUE(FILTER(Col_K, crit, "None")),
    TEXTJOIN(line_break, , distinct)
)