Multiple Condition Do Loop

I have spent sometime searching for why this isn't working but to no avail...

What I am trying to do is loop through a column of data until condition 1 is met then check if condition 2 is met 4 cells to the left. Below is the code, if I change the "And" to "Or" it works when either condition is met but if it is "And" it doesn't. Thank you for the help!

Range("G5").Select
Do
If Selection.Value = Range("M4") And Selection.Offset(0, -4) = Range("I4") Then
Range(Selection.Offset(0, -4), Selection).Copy
Else
Selection.Offset(1, 0).Select
End If
Loop

Hello redpanda,

You need to check that the first condition is true before check the next condition. You will need a nested If...Then to do this. Try this revision.

Range("G5").Select
  Do
    If Selection.Value = Range("M4") Then

      If  Selection.Offset(0, -4) = Range("I4") Then
         Range(Selection.Offset(0, -4), Selection).Copy
      End If

    Else
      Selection.Offset(1, 0).Select
    End If
  Loop