vlookup path not working in UDF (User Defined Function)

I am creating a UDF the contains a vlookup and it is not working unless the file is open. I beleive the path is not working. Does anyone have a any suggestions or work arounds for creating a UDF that might work? Below is the code:

HTML Code: 

When using the Forum you are expected to wrap code snippets with code tags - see the Rules.