TEXTJOIN with FILTER function

[ThatOneDude]

I am using the Filter function on a specific range. It finds two results. I then want to use Textjoin to input both results into one cell. However, sometimes one of the results is a blank cell. In this case, I actually want to see the blanks but I want it to return a value of "Blank" or "Missing" or something like that because I need to know that there is data missing in my database.

Is there some way to control how it displays the blanks?

Example:
=TEXTJOIN(CHAR(10),FALSE, UNIQUE(FILTER(Oracle!$L$1:$L$30000, (ISNUMBER(SEARCH($D3, Oracle!$K$1:$K$30000))))))

Everything is working just fine except for this part. The FILTER results are {"";"44V50F"} in this case. With the FALSE in the TEXTJOIN function, it will display the empty line and the "44V50F" in the line below it but I want the blank to actually say "Blank" so I know there is data missing. I've tried SUBSTITUTE to replace the blank with text and IF statements to correct this but I'm at a loss.

Is this even possible?

Can I make these results display in the cell like:
Blank
44V50F

 

[Fluff]

Hi & welcome to MrExcel.
How about

=LET(f,UNIQUE(FILTER(Oracle!$L$1:$L$30000, (ISNUMBER(SEARCH($D3, Oracle!$K$1:$K$30000))))),TEXTJOIN(CHAR(10),FALSE, IF(f="","Blank",f)))

 

[ThatOneDude]

Wow, thank you so much! Two days of wracking my brains and it only took a few minutes to get the answer. I'm not familiar with the LET function so I'll need to check that out. Thank you!

 

[Fluff]

Glad to help & thanks for the feedback.