title: using hyperlink in a vlookup function
body: <p>very new to this and only just managed the vlookup, anyway, 
  i have a workbook which contains two Sheets. On Sheet1 I have the following formula <code>(=VLOOKUP(CZ54,Sheet2!$A$1:$Y$176,3,FALSE))</code> which displays the ID number from Sheet2. This works correctly but how do I get to appear as a hyperlink so once clicked it goes to the specific cell it got from the vloopkup on Sheet2?</p>
  
  <p>I have tried <code>=HYPERLINK(VLOOKUP(CZ54,Sheet2!$A$1:$Y$176,3,FALSE</code>) but I get the error "Cannot get the specified file".</p>
  
  <p>I would be grateful if anyone can point me in the right direction, thank you.</p>