=HYPERLINK(VLOOKUP($B$1,Data!$A:$AY,4,FALSE))
Pretty simple, by all accounts should work.
I get the correct result in the cell, underlined, like a hyperlink should be, but when I click on it I get - "Cannot open the specified file".
Any ideas?
=HYPERLINK(VLOOKUP($B$1,Data!$A:$AY,4,FALSE))
Pretty simple, by all accounts should work.
I get the correct result in the cell, underlined, like a hyperlink should be, but when I click on it I get - "Cannot open the specified file".
Any ideas?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks