Vlookup/Hyperlink Error

[clumzyfish]

Hi All,

I'm trying to use the Hyperlink function on a VLOOKUP and it's returning the incorrect address. The formula is on sheet1, and the list of hyperlinks is on sheet2.

Does anyone know why? the links are within SharePoint and it has the correct file name, just the incorrect folder path.

Thanks!

 

[bensonsearch]

Hi All,

I'm trying to use the Hyperlink function on a VLOOKUP and it's returning the incorrect address. The formula is on sheet1, and the list of hyperlinks is on sheet2.

Does anyone know why? the links are within SharePoint and it has the correct file name, just the incorrect folder path.

Thanks!

Hi,
could you provide an example of the formula/code?

 

[clumzyfish]

Thanks for inquiring. I determined that it was an issue with the vlookup and the table query that I was using as the range. I had to do a workaround to get it to recognize the correct values. Thanks!