Hyperlink(vlookup

New Contributor
Hi
I have a list of hyperlinks on sheet WI column B with a descriptions in in column A on sheet 1 column c I have the same descriptions I’m using =Hyperlink(Vlookup(C4,WI!$A$1:$B$58,2,FALSE)) this is bringing over the info from the WI sheet but when I click the hyperlink it says “Cannot open the specified file.” 1 other note this hyperlinks are direct to a file I have on the computer. Any help I would greatly appreciate
1 Reply
Change your formula to:
=Hyperlink("file:"&Vlookup(C4,WI!$A$1:$B$58,2,FALSE))