Sub es()
Dim t(), t1(), t2(), i As Long, x As Long, m As Object, z
Set m = CreateObject("Scripting.Dictionary")
t2 = Range("a1:b" & Cells(Rows.Count, 1).End(3).Row)
t = Range("c1:d" & Cells(Rows.Count, 1).End(3).Row)
For i = 1 To UBound(t2)
z = t2(i, 1) & t2(i, 2)
If Not m.Exists(z) Then m.Add z, z
Next i
ReDim t1(1 To UBound(t), 1 To 2)
For i = 1 To UBound(t)
z = t(i, 1) & t(i, 2)
If m.Exists(z) Then
x = x + 1
t1(x, 1) = t(i, 1): t1(x, 2) = t(i, 2)
End If
Next i
[E1].Resize(x, 2) = t1
End Sub