Find and return yes/no

[MojoJojo2023]

In the below code, I am attempting to find each cell in a given range in a reference data worksheet I have set up. If it does find the cell value within the reference data range, it will return a yes or otherwise return a no. As of right now, I am returning only no for every cell in the range, even though there are matches. Does anyone know a fix that would correct this?:

Sub MatchPB()

Dim wb As Workbook
Dim bingo As Range


For Each cell In PB.Range("A2:A104")
    With RData.Range("A2:A50")
        Set bingo = .Find(What:=cell.Value, LookAt:=xlWhole, MatchCase:=False, SearchFormat:=False)
        If bingo Is Nothing Then
        cell.Offset(0, 27).Value = "Yes"
        Else: cell.Offset(0, 27).Value = "No"
        End If
    End With
Next

End Sub

Thanks in advance!

 

[Osvaldo Palmeiro]

Try:

If Not bingo Is Nothing Then

 

[MojoJojo2023]

I inserted that into my code, and it is still returning "No" for all items, even if a match formula should return yes.

 

[Osvaldo Palmeiro]

Could you post the full code you're running and a shot of your sheet using XL2BB