|
本帖最后由 Zipall 于 2014-3-18 11:43 编辑
E2
=IF(ISNA(MATCH(LEFT(A2,2)&"*",省!A:A,)),"",INDEX(省!A:A,MATCH(LEFT(A2,2)&"*",省!A:A,)))
向下填充
vba的话可以用range.find- Sub 提取省()
- Dim arr, brr, k%, m%
- Row = Cells(Rows.Count, 1).End(3).Row
- arr = Sheets("sheet1").Range("a1:a" & Row)
- For k = 2 To UBound(arr)
- Set t = Nothing
- Set t = Sheets("省").Range("a:a").Find(Left(arr(k, 1), 2))
- If t Is Nothing Then arr(k, 1) = "" Else arr(k, 1) = t.Value
- Next k
- Sheets("sheet1").Range("e1").Resize(UBound(arr)) = arr
- End Sub
复制代码 |
|