Hyperlink(vlookup

%3CLINGO-SUB%20id%3D%22lingo-sub-2892919%22%20slang%3D%22en-US%22%3EHyperlink(vlookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2892919%22%20slang%3D%22en-US%22%3EHi%3CBR%20%2F%3EI%20have%20a%20list%20of%20hyperlinks%20on%20sheet%20WI%20column%20B%20with%20a%20descriptions%20in%20in%20column%20A%20on%20sheet%201%20column%20c%20I%20have%20the%20same%20descriptions%20I%E2%80%99m%20using%20%3DHyperlink(Vlookup(C4%2CWI!%24A%241%3A%24B%2458%2C2%2CFALSE))%20this%20is%20bringing%20over%20the%20info%20from%20the%20WI%20sheet%20but%20when%20I%20click%20the%20hyperlink%20it%20says%20%E2%80%9CCannot%20open%20the%20specified%20file.%E2%80%9D%201%20other%20note%20this%20hyperlinks%20are%20direct%20to%20a%20file%20I%20have%20on%20the%20computer.%20Any%20help%20I%20would%20greatly%20appreciate%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2892919%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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))