Forum Discussion
Solved
Find matches from one list in another
Hi, I am a Quality Engineer and have been working on a project to find out if minor defects in parts cause parts to fail later in the production process. I have an inspector inspecting the pa...
My function slightly different from OliverScheurich :
=ISNUMBER(MATCH("*"&A2:A15&"*",""&G$2:G$23,0)) or =ISNUMBER(XMATCH("*"&A2:A15&"*",""&G$2:G$23,2))
=BYROW(A2:A13,LAMBDA(row,ISNUMBER(SEARCH(row,TEXTJOIN(" ",,SUBSTITUTE(SUBSTITUTE($D$2:$D$11,CHAR(10),""),",",""))))))You can try this formula which spills the results.
=ISNUMBER(SEARCH(A2,TEXTJOIN(" ",,SUBSTITUTE(SUBSTITUTE($D$2:$D$11,CHAR(10),""),",",""))))Without LAMBDA you can try this formula which doesn't spill but can be copied down.
Both formulas return TRUE/FALSE (WAHR, FALSCH in german).