Si la liste 2 est à géométrie variable, cela se complique
Par macro cela donne:
Sub Test()
For i = 2 To Cells(Rows.Count, "A").End(xlUp).Row
For j = 2 To Cells(Rows.Count, "C").End(xlUp).Row
Cells(i, "A") = Replace(Cells(i, "A"), Cells(j, "C"), "")
Next
Next
End Sub