1 Data Column, 3+ Text Search Criterias, 1 Output Column

Hi again excel geniuses, I'm sorry to come back to you but I have a new question to expand on what I previously asked back in mid-March. (https://www.excelforum.com/excel-for...mn-output.html)

Please could you help me create a new formula or improve the following one, to change it from 2 text search criteria to 3 or more?:

Formula:

Please Login or Register  to view this content.

I have uploaded a sample workbook with my desired results for 3 and 4 text search criteria's, but would really love to have the option to expand this.
To me this feels like something that should be easy but with many google searches I haven't be able to find anything that help so am turning to you in the hope there is a solution.

I'm using MS365 Excel Version 2208 on PC, thanks in advance.

Damn, is it really that easy!

Thank you so much, I'm new to the MMULT formula and think that shows but take nothing away from you for such an effective and quick solution.

Rep added and post marked as solved, thanks again, I really appreciate your help.