Sub es()
Dim d As Object,a,b,i as long
Set d = CreateObject("scripting.dictionary")
For Each C In [A2:A13]
d(C.Value) = C.Offset(, 1).Value2
'd(C.Value2) = C.Offset(, 1).Value2
'd(C.Value) = ""
Next C
a = d.keys: b = d.items
For i = 0 To d.Count - 1
MsgBox a(i)
MsgBox b(i)
Next i
d.RemoveAll
End Sub