hyperlink in a vlookup

[skip2mylew]

Is there a way to include a hyperlink in a vlookup formula to strengthen the connection. I have a vlookup up formula in a workbook that is connected to another workbook. The workbook is in dropbox and when I get on a different computer to use the workbook the connection is broke. My hyperlinks still work though.

The vlookup and hyperlink I use are below:

vlookup - =IF($A25="","",VLOOKUP($A25,'[case lot list for listmaking.xlsm]Overstock & Fillers'!$I$2:$O$27,6,FALSE))

hyperlink - ..\Case%20Lot%20List\Case%20Lot%20List%20for%20Listmaking.xlsm