matching and copying data from one sheet to another

[danwilkin]

I have 2 sheets. one is the price list sheet including a column (col D) containing numbers (these are not calculated). i want to extract these numbers into the other sheet which is a sheet of invoices. i need to copy the data (col D).
In each row there are 3 conditions to match. col a and col b and col c must match in both sheets in order to satisfy copying the info from col D.
Is there an easy way to do this?

 

[Warship]

With VBA try: (not tested)

Sub Update_Invoices()
    Dim dataInv As Range
    Dim dataPri As Range
    Dim i As Integer
    Dim p As Integer
    
    Set dataInv = Sheets("Invoice").Cells(1, 1).CurrentRegion
    Set dataPri = Sheets("Price").Cells(1, 1).CurrentRegion
    
    For i = 1 To dataInv.Rows.Count
        For p = 1 To dataPri.Rows.Count
            If dataInv.Cells(i, 1) = dataPri.Cells(p, 1) And _
                dataInv.Cells(i, 2) = dataPri.Cells(p, 2) And _
                dataInv.Cells(i, 3) = dataPri.Cells(p, 3) Then
                
                dataInv.Cells(i, 4) = dataPri.Cells(p, 4)
                Exit For
            End If
        Next p
    Next i
End Sub

 

[danwilkin]

Thanks warship am trying this now will let you know later