How to find value from sheet 2 and paste in sheet 1 with match.

[Nishu]

Hi All,
Hope you are doing well, I am stuck in a problem where i have to loopkup value from sheet 2 and have to changes in sheet 1.
i am using match formula but when sheet 2 lookup value is not present in sheet 1 it shows the error.

Attached is the file fyr,Please clarify how to resolve.

thank you

 

[Marc L]

Hi !

As a beginner starter :​

Sub Demo1()
        Dim R&, V
    With Sheet2
        For R = 2 To .UsedRange.Rows.Count
            If .Cells(R, 1).Value > "" And .Cells(R, 3).Value > "" Then
                V = Application.Match(.Cells(R, 1).Value, Sheet1.UsedRange.Columns(1), 0)
                If IsNumeric(V) Then Sheet1.Cells(V, 3).Value = .Cells(R, 3).Value
            End If
        Next
    End With
End Sub

Do you like it ? So thanks to click on bottom right Like !
​