Using the #spill error as the result

I'm trying to use the filter function to generate some tables

Now my one table has multiple rows that correlate to just one row in the Table I want to generate.

If there is only one row that fulfills the criteria, I want the result to be one thing, and if I get a #spill error I would like it to say another thing (but not #spill). Is there any way to do this? Is there an easier way to do it?

There is a column in the original data that contains the answer I want, but since it's in multiple rows I can't figure out how to not get the #spill result.

I can't share any data as it is for work and English is not my native language so I'm sorry if I didn't explain properly.