Luigi802 New Member Dec 20, 2017 #1 So I'm trying to use VLOOKUP in conjunction with a hyper link, I've tried this formula =HYPERLINK(VLOOKUP(name,table,column,0),name) but when I click it, it says "cannot open the specified file"
So I'm trying to use VLOOKUP in conjunction with a hyper link, I've tried this formula =HYPERLINK(VLOOKUP(name,table,column,0),name) but when I click it, it says "cannot open the specified file"
Chihiro Excel Ninja Dec 20, 2017 #2 Without sample workbook it's hard tell. What does VLOOKUP return without the Hyperlink?
