=HYPERLINK(VLOOKUP($B$1,Data!$A:$AY,4,FALSE))

Pretty simple, by all accounts should work.

I get the correct result in the cell, underlined, like a hyperlink should be, but when I click on it I get - "Cannot open the specified file".

Any ideas?