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.
Kristin2185, in that first reference of your formula you're referencing columns I and J, it should be only column J.
=TAKE(FILTER($J$6:$J$13...