Navigate from one cell to another cell in the same google docs sheet

[Sasikanth]

I want to navigate from one cell to another cell in the same google docs sheet.
For example, I have 10 rows on the top.. from which if i click on a cell should take me to the referenced cells below (say a cell in row 500). Something like hyperlink which i click should take me to the cell i want. Both the cells are in the same sheet.
Please some one help me on this

 

[Chihiro]

You'll probably get better answer if you asked in Google Doc forum/group.
https://productforums.google.com/forum/#!forum/docs

AFAIK - There is no way to jump to another cell directly using formula. You'd need script.

Try link below.
http://igoogledrive.blogspot.ca/2013/06/google-spreadsheet-navigate-to-another.html