Need a VBA code to check if condition across column replace with new text in cell F&G

Hi experts

i need an solution with rawdata

i have 4 column in if condition calculation get replace with desired value in F & g

if G col "PO" and B = "G5 PIT" then Under account type if values are met these 4 condition "BH-11710","ER-13855","PG-18895","US-2015-134026" in list select then i want replace with colmn F as MYOB_INVOICE and G as MYOB

see i and j col is my desired result

find the attachment.

thanks alot

According to your attachment a VBA demonstration as a beginner starter :

PHP Code: 

Sub Demo1()
    For R& = 2 To [A1].CurrentRegion.Rows.Count
        If Cells(R, 2) = "G5 PIT" And Cells(R, 7) = "PO" Then
            If IsNumeric(Application.Match(Cells(R, 4), [M1].CurrentRegion, 0)) Then
                Rows(R).Columns("F:G") = Array("MYOB_INVOICE", "MYOB")
            End If
        End If
    Next
End Sub 


► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄

hi experts its works small changes in code i want set criteria lookup range in another new sheet or add criteria in code? pls help on this

Hi breadwinner.

Please try this code:

Please Login or Register  to view this content.

Thanks Boss!! Its solved Thanks for your time