Results 1 to 8 of 8

Doing partial match using Lambda

Threaded View

  1. #1
    Registered User
    Join Date
    11-08-2022
    Location
    singapore
    MS-Off Ver
    365
    Posts
    16

    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))) 
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Match and Extract -LAMBDA,MAP,FILTER
    By paradise2sr in forum Excel Formulas & Functions
    Replies: 32
    Last Post: 02-02-2024, 04:55 AM
  2. Replies: 11
    Last Post: 11-26-2022, 04:58 PM
  3. Index / match type problem, with partial string match
    By bkper087 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-05-2019, 02:42 AM
  4. Fuzzy match formula to match partial email string in another list?
    By Akshay in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-26-2018, 01:51 PM
  5. [SOLVED] Lookup partial values and if match return partial value from another cell
    By Renejorgensen in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-01-2017, 07:53 AM
  6. Replies: 2
    Last Post: 09-27-2014, 04:34 PM
  7. Replies: 0
    Last Post: 09-21-2013, 09:03 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1