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?

 

[Snake3y3s]

I have both as part of office 365
but, as stated in the first post, for this project, I am using Excel online.

 

[Fluff]

How about

=HYPERLINK("#"&ADDRESS(MATCH(N776,'PC Spec CPT'!$C$3:$C$2000,1)+2,3,,,"PC Spec CPT"),"Click here")

 

[Snake3y3s]

That formula that Fluff gave is almost there... it is taking me to the other sheet, but to the incorrect value/cell.
The correct value (on the main sheet in cell N776) is "TASCP-1421", this value appears in C16 in the "PC Spec CPT" sheet

The formula above goes to the "PC Spec CPT" Sheet, but it points to a value of "TASCP-1077" which is in cell C85

 

[Fluff]

Try changing the 1 to a 0 for an exact match

 

[Snake3y3s]

THAT WORKS PERFECTLY!
thank you so much! been trying to figure this out for a week now O_O
With the formula you posted, I was trying to change the arguments/options on the address part (so the +2,3,,, part) and somehow missed the 1 in the MATCH part of the formula.
I also assumed you needed a INDEX to use a MATCH function.

how does the + work in this case?

 

[Fluff]

If a match was found in C3 the MATCH function would return 1 so you need to add 2 to take you to row 3