How do I add a Hyperlink to a vlookup

I'm having a problem getting a hyperlink to work when adding it to a vlookup. The vlookup is looking at a page number and returning the named drawing from an Auto Desk Inventor File. I'm trying to get the returned drawing name to become a hyperlink to open the drawing. I would rather have this added to the formula so if a page number ever changes the hyperlink will change to the correct drawing also. Here is what I have so far but it is just returning an error of " cannot open the specified file".
=HYPERLINK(IF(E5="","",(VLOOKUP(E5,'Inventor Import'!$A$2:$E$200,5,FALSE))))

Any help would be greatly appreciated.

TM

After trying many tips from user I was able to add the location of the drawing files I wanted the hyperlink to open and it worked. This is what I ended up with.

=HYPERLINK(IF(E5="","","\\sbs03\sys\ENGERNG\DRAWINGS\Stock Plates & Clips\Bolted Clips-Inv\"&(VLOOKUP(E5,'Inventor Import'!$A$2:$E$200,5,FALSE))&".dwg"),VLOOKUP(E5,'Inventor Import'!$A$2:$E$200,5,FALSE))

Thanks for the help.