Doing partial match using Lambda

Hi everyone, I need help on my lambda formula. You can have a look at my attached excel file. Column A of my excel file is all the naming conventions in accord the Vendors' data . Column B is the naming of all the vendors in accord to my naming. You can see the lambda formula in column C to do a partial match between column A and B. It looks up the vendor naming list and try to match to my listing and gives the Vendor naming in column C.
How can I enhance my lambda formula further to look at the first names? For eg , from the excel file, cells C3 and C4 are extracted wrongly.
Cell C3 should pull "bbb mediaa" as it starts with bbb.
Please help me on this.Thanks for the help in advance.

This is my lambda formula

PHP Code: 

=LET(a,$A$3:$A$14,c,BYROW(--ISNUMBER(SEARCH(TEXTSPLIT(B3," ",,1),a)),LAMBDA(x,SUM(x))),INDEX(a,XMATCH(MAX(c),c))) 


Perhaps,

Please Login or Register  to view this content.

Thanks so much for this input! It seems to work well!

Hi, you are right. This formula doesn't help me completely. However, for a quick solution last week , it managed to help me for a quick fix.
I hope someone can help me to refine the formula. Hence, I would like to keep the thread open for the inputs that I want.

Could you provide all expected results in your sample file?

Hi I am so sorry for not reverting back to you on time. Have been so busy. I have made a note to share the expected results once my busy schedule is over in next few days and thanks so much for your help!