VBA## on error go to多次跳转问题## 求教

VBA## on error go to多次跳转问题## 求教

代码如下：

1. Function Owner(CPN as string，WholePN as range，Versionless as range) as string
3. Err.Clear
4. On Error GoTo Line1
5. Owner = WorksheetFunction.Vlookup(CPN, WholePN, 3, 0)
6. GoTo FinalOwner
8. Line1：
9. Err.Clear
10. On Error GoTo Line2
11. Owner = WorksheetFunction.Vlookup(Left(CPN,Len(CPN) - 3), Versionless as range, 2, 0)
12. GoTo FinalOwner
14. Line2:
15. Err.Clear
16. On Error GoTo Line3
17. Owner = WorksheetFunction.Vlookup(Left(CPN,Len(CPN) - 1), WholePN, 3, 0)
18. GoTo FinalOwner
20. Line3:
21. Err.Clear
22. Owner = “NA”
24. FinalOwner:
26. End Function

测试发现第5行和第11行的结果是可以出来，但是后面两种情况怎么都是"#VALUE!"

按道理不管CPN是个啥，结果最差也是"NA"才对呀，为啥出来"#VALUE!"?求大神指教。谢谢!