creating a hyperlink in a cell after a different input is added in that cell

[banneduser123]

i'm curious if this is possible:

first, lets say at the bottom of my worksheet i have cells A100-A110 each containing the text of either "V1", "V2"....."V10",


now say if i enter into a blank cell the text "V1", is there a way to create a formula where it turns that cell into a hyperlink to the respective cell at the bottom of my worksheet? e.g. clicking on the cell that has the text "V5" in it will bring me to the cell at the bottom of the worksheet that has the text "V5" in it as well...

any help is much appreciated...
thanks