|
发表于 2017-2-28 13:27
|
显示全部楼层
本楼为最佳答案
- Sub Tj()
- Dim Rng As Range, Arr
- Set Rng = [d1:e5]
- Arr = [a1].CurrentRegion
- For i = 1 To UBound(Arr)
- Cells(i, 2) = Cells(Rng.Find(Arr(i, 1), , , xlWhole).Row, "F")
- Next
- MsgBox "查表完成"
-
- End Sub
- Sub TJ2()
- Dim Arr, Brr
- Brr = [d1:f5]
- Arr = [a1].CurrentRegion
- For i = 1 To UBound(Arr)
- For j = 1 To UBound(Brr)
- If Arr(i, 1) = Brr(j, 1) Or Arr(i, 1) = Brr(j, 2) Then
- Cells(i, 2) = Brr(j, 3)
- End If
- Next
- Next
- MsgBox "查表完成"
- End Sub
复制代码 数组和find两种方法实现,你看一下,你这天天都是弄啥东西啊。
|
评分
-
查看全部评分
|