I am sorry to push into this post, but I am trying something similar with no results. I am getting the cannot open the specified file message:
=HYPERLINK(VLOOKUP("jason", calls!A1:A10, 1, FALSE))

I even tried this with the same results:
=HYPERLINK(VLOOKUP("tor", INDIRECT("calls"&"!$A$1:$A$10"),1, 0))

I basically want VLOOKUP to search column 1, A1-A10 on the calls page. Then take the results and assign a hyperlink to it. Any idea as to why I am still getting this message?