Forum Discussion
Kristin2185
Dec 08, 2022Copper Contributor
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...
- 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")
Kristin2185
Dec 09, 2022Copper Contributor
Thanks, this works perfectly!
Lorenzo
Dec 09, 2022Silver Contributor