偷懒的:
Sub aa()
Dim i, ar1(), ar2()
'i = [g65536].End(xlUp).Row
'ar1 = Range("g2:g" & i).Value
ar1 = Range("g2:g8").Value
i = [a65536].End(xlUp).Row
ar2 = Range("c1:c" & i).Value
For i = 1 To UBound(ar1)
ar1(i, 1) = ar2(ar1(i, 1), 1)
Next i
[h2].Resize(i - 1) = ar1
End Sub