VBA lookup when not found

[blossomthe2nd]

Hi Experts

I hope someone can help - I have a sheet call Paste and one called look up -

On the lookup tab there is a list of accounts (the numbers of which varies perday) in column B - Using VBA I wish to do a vlookup on tab Paste looking in Column B and returning Column Cs value -

I have tried a few Codes that I have found online but in all cases whenever an account is not found the cose just stops rather than moving to next account

Can anyone please advise ?

Thanks

A

 

[blossomthe2nd]

Dim rngData     As Range
    Dim rngLookup   As Range
    Dim Lookup      As Range
    
    'Set lookup value
    Set rngLookup = Sheets("Results").Range("B2")
    
    'Set range you want to search
    Set rngData = Sheets("Paste R4037").Range("B:B")
    
    For Each Lookup In rngData
        If Lookup.Value = rngLookup.Value Then
            rngLookup.Offset(0, 3) = Lookup.Offset(0, 3)
        End If
    Next Lookup

Hi Guys

The above is what I'm working on - I ned dit to move on even if result isnt found

Thanks

A