Forum Discussion

Vic320's avatar
Vic320
Copper Contributor
Jan 30, 2023
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...
Formulas and Functions
  • dscheikey's avatar
    dscheikey
    Jan 30, 2023

    Vic320 

    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's avatar
dscheikey
Bronze Contributor
Jan 30, 2023

Vic320 

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))

 

Vic320's avatar
Vic320
Copper Contributor
Jan 30, 2023

dscheikey  I ended up using your solution, mostly because it was easier for me to understand but it works great.  Thank you!

Resources