My vlookup doenst show the links or it doenst have hyperlink working

My vlookup doesn't show the links or it doesn't have hyperlink working. The sample file attached named (1) test master file - it has all links and will be used as master file and to be used by myself. The (2nd) file named "file2" will be provided to someone and they will access it via Sharepoint.

I use vlookup but the link in the master file doenst working in the file2 cell. Please if you could provide a working formula. It could be vlook up combination of vlookup +hyperlink or something else.

Additionally, I want file2 cell b2 to be auto-updated every time I made changes in the masterfile cell b2 also.

Update: In the master file B2. The links are edited (sample. the actual https google url - somehow I'm not allowed to enter the URL] into Google.

The working formula is =IFERROR(HYPERLINK(VLOOKUP(A2,'[test master file.xlsx]Master file'!$A:$B,2,0)),"")

This will only work if I revert back the link (b2) from Google into the actual URL

I need it to be simplified and not a long URL.

up- please help