Forum Discussion
Solved
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...
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")
I use Office365, on a MacBook.
Got the wanted results now, thank you so much!!
I think the issue was that this formula populates two columns with data and so I got a #spill error that I didn't understand. Worked perfectly when I made sure there were two empty columns available.
Although... In row 18, the formula doesn't catch the "fb-rem" in the middle of the string. Any ideas on how to address that?
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")- Thanks, this works perfectly!