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.
Bookmarks