Broken Hyperlink When Using Vlookup

Hello everyone
I've been trying something on excel and I've been searching for a long time. I can't find any solution.
So I have a problem that I want vlookup to my hyperlinks and my hyperlinks are attached another sheet on the same file. When I use =HYPERLINK(VLOOKUP(A2;Sheet2!$A$2:$B$5;2;0)) formula I get an error 'The address of this site is not valid. Check the address and try again.' But I already don't use an 'website link'.
I have attached the Excel file as an example of what I'm trying to do. Your help is much appreciated.
Regards