Sub Test()
Dim sh1 As Worksheet, sh2 As Worksheet, I&, J&
Set sh1 = Worksheets(1): Set sh2 = Worksheets("ANGLI_Liste")
sh2.Activate
Dim DL As Long
DL = sh2.Cells(Rows.Count, 2).End(xlUp).Row
sh2.Range("B2:D" & DL).Name = "_BAZ2"
With Application
.ScreenUpdating = False
For I = 6 To sh1.Range("G" & Rows.Count).End(xlUp).Row
If WorksheetFunction.CountIf([_BAZ2], sh1.Cells(I, "G")) > 0 Then
sh1.Cells(I, "A") = .VLookup(sh1.Cells(I, "G"), [_BAZ2], 3, 0)
End If
Next
End With