Forum Discussion

Kristin2185's avatar
Kristin2185
Copper Contributor
Dec 08, 2022

XLOOKUP partial match text

Hi,    I'm having an issue with partial matching text in the lookup cell of my X lookup function.   Formula: =XLOOKUP("*"&A2&"*";$I$6:$I$13;$J$6:$J$13;"not found";2)    A2 = app:android:sv:cod...
  • Lorenzo's avatar
    Lorenzo
    Dec 08, 2022

    Hi Kristin2185 

     

    Slightly different approach that should work if your Source strings are as consistant as those you shared where there's a semi-column following the keywords you want to match

     

     

    in C2:

    =FILTER(TBL_Lookup[Mapping], ISNUMBER(SEARCH(TBL_Lookup[Keyword],A2)), "No match")

     

Resources