Hyperlink with Vlookup in same Workbook

[Snake3y3s]

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?

 

[Jeffrey Mahoney]

When I create a hyper link like that, it works.

Can you tell me why you added a # sign at the front of the Sheet/Cell reference in the first example?
In your second example, I don't know what N776 holds or what the range looks up.

 

[Snake3y3s]

so the first formula works... yes...
the "#" is to tell Excel that it needs to search in the same workbook, just a different sheet.

N776 just contains a value of TASCP-1446
its just the value I need to search for in the other sheet and then link to it

 

[Jeffrey Mahoney]

When I reference a cell on another sheet I don't need to use the #.

 

[Snake3y3s]

Are you using web excel or app/program excel.
if I dont use the "#" it tries to open a new window with a link to B3... I.e. "https://eg.sharepoint.com/General/Facilities/Asset code/room1-01" Which is what is currently in cell B3 on that sheet

 

[Jeffrey Mahoney]

Well, I didn't know you were using the Web version of Excel. I've not used that. Strange

 

[Snake3y3s]

Well, I didn't know you were using the Web version of Excel. I've not used that. Strange

Web Excel/Office 365 Excel

 

[Snake3y3s]

sigh... you cant edit posts....
are they not the same thing? The document is on sharepoint so, using the web based Excel

 

[Jeffrey Mahoney]

You might want to update your profile

 

[Jeffrey Mahoney]

Here is one site outlining differences
Excel Online vs Excel Desktop: What's the Difference?