Sub main()
Dim a(2, 2) As String
a(1, 1) = "CK"
a(1, 2) = "量产品"
a(2, 1) = "CQ2"
a(2, 2) = "其他"
'其余省略
For i = 1 To Sheets(1).UsedRange.Rows.Count
For j = 1 To UBound(a)
If Left(Cells(i, 2), Len(a(j, 1))) = a(j, 1) Then
Cells(i, 3) = a(j, 2)
End If
Next j
Next i
End Sub