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")
Hi,
What do the rightmost 2 and -2 do in the XLOOKUP formula?
=XLOOKUP(A6,A2:A3,B2:I3,"--",1,-2)
What do the rightmost 2 and -2 do in the XLOOKUP formula?
=XLOOKUP(A6,A2:A3,B2:I3,"--",1,-2)
I dont reaaly dont understand what is its function -2
=XLOOKUP(A6,A2:A3,B2:I3,"--",1,-2)