Compare 2 cells provide a specific response

[mhumphries]

Hi all

I have a sheet that is gathering information from several other sheets using vlookup.
I have tried several functions, cannot get the right function to give a specific result

My question is

I need a specific response in column K
The response is created by determining what is in column i and column j

example

Column i = not_started column j = Complete_via_Payment_plan column k needs to give i5 (see row 8)

Column i = Complete_via_Payment_plan j = not_started column column k needs to give i3 (see row 25)

Wording can vary in column i and j, example completed or pending_payment etc.

Word other than not_started needs to give i3 or i5 response.

Your help appreciated

 

[RedBeard]

Something like this?

Private Sub test()

Dim LastRowI As Long
Dim i As Long

LastRowI = Sheet1.Cells(Sheet1.Rows.Count, "I").End(xlUp).Row

For i = 1 To LastRowI

    If Sheet1.Range("I" & i).Text = "Not_Started" And Sheet1.Range("J" & i).Text = "Not_Started" Then
    
        Sheet1.Range("K" & i).Value2 = ""
        
    ElseIf Sheet1.Range("I" & i).Text <> "" And Sheet1.Range("J" & i).Text = "Not_Started" Then

        Sheet1.Range("K" & i).Value2 = "i3"
        
    ElseIf Sheet1.Range("I" & i).Text = "Not_Started" And Sheet1.Range("J" & i).Text <> "Not_Started" Then
    
        Sheet1.Range("K" & i).Value2 = "i5"

    End If
    
Next i

End Sub