Forum Discussion
Vic320
Jan 30, 2023Copper Contributor
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...
- Jan 30, 2023
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))
dscheikey
Jan 30, 2023Bronze Contributor
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))