Lookup and match multiple values separated by commas in a cell and produce matched value

[abdulrahim845]

C2:C7 has single non-sequential numbers and B2:B7 has multiple numbers separated by commas in each cell. I want to match the C2 numbers in B2:B7 and get the output of the corresponding matching number in D2. Can anyone help me formulate this? Thanks

 

[abdulrahim845]

yes.

That's Great! let you know by applying it to the new data set.

 

[shinigamilight]

try this

Sub wrc()
        Dim regex As Object
        Set regex = CreateObject("vbscript.regexp")
        Dim mc, s
        Dim k As Boolean
        Dim p As Long
        regex.Global = True
        regex.Pattern = "[0-9]+"
         
        For p = 2 To Range("B" & Rows.Count).End(xlUp).Row
            Set mc = regex.Execute(Range("B" & p).Value)
            
            On Error Resume Next
            
            For Each s In mc
                 k = WorksheetFunction.Match(CStr(Int(s)), Range("A:A"), 0)
                 If k = True Then
                    Range("C" & p).Value = s & "," & Range("C" & p).Value
                    k = False
                End If
            Next s
            
            On Error GoTo 0
        Next p
        
        
End Sub