I am using Web Excel.
I have a value on one sheet in a workbook, I can VLOOKUP the value on another sheet just fine.
Now I would like to make a hyperlink to the other sheet and to the Cell containing that specific value but it is trying to open it as a URL
So its loading a new page and showing a error 404 instead of going to the other page and to the value.
so using this works 100%:
=HYPERLINK("#'PC Spec CPT'!B3","Click here")
but this just sends you to that cell.
if I use this:
=HYPERLINK(VLOOKUP(N776,'PC Spec CPT'!$C$3:$L$2000,1,FALSE),"Click here")
it gives the 404 error
I have tried quite a number of iterations using the "#" & setup, but have not been successful.
what am I missing here?
I have a value on one sheet in a workbook, I can VLOOKUP the value on another sheet just fine.
Now I would like to make a hyperlink to the other sheet and to the Cell containing that specific value but it is trying to open it as a URL
So its loading a new page and showing a error 404 instead of going to the other page and to the value.
so using this works 100%:
=HYPERLINK("#'PC Spec CPT'!B3","Click here")
but this just sends you to that cell.
if I use this:
=HYPERLINK(VLOOKUP(N776,'PC Spec CPT'!$C$3:$L$2000,1,FALSE),"Click here")
it gives the 404 error
I have tried quite a number of iterations using the "#" & setup, but have not been successful.
what am I missing here?