Hi
I'm trying to do a vlookup to return a hyperlink.
Have done this formula - =HYPERLINK(VLOOKUP($C$8,'Linked Items'!A:H,2,FALSE))
However my excel file is stored on sharepoint and for some reason the hyperlink is putting the sharepoint link as a prefix to the desired hyperlink which makes the address incorrect. Any idea how i can get to just return the hyperlink address from the cell it returns?
I'm trying to do a vlookup to return a hyperlink.
Have done this formula - =HYPERLINK(VLOOKUP($C$8,'Linked Items'!A:H,2,FALSE))
However my excel file is stored on sharepoint and for some reason the hyperlink is putting the sharepoint link as a prefix to the desired hyperlink which makes the address incorrect. Any idea how i can get to just return the hyperlink address from the cell it returns?