|
发表于 2019-3-12 02:38
来自手机
|
显示全部楼层
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
本帖最后由 lss001 于 2019-3-12 11:18 编辑
Function JG(r As Range)
Dim dic As Object, wb As Workbook,arr,k$, i&,dic As Object
Set dic = CreateObject("scripting.dictionary")
Set wb = GetObject(ThisWorkbook.Path & "\籍贯对照表.xlsx")
arr = wb.Sheets("籍贯").Range("a1:b6000")
wb.Close SaveChanges:=False
For i = 1 To UBound(arr)
k = arr(i, 1)
If Not dic.exists(k) Then dic(k) = arr(i, 2)
Next
k = Left(r.Value, 6)
If dic.exists(k) Then JG = dic(k) Else JG = ""
End Function
|
|