Reverse hyperlink

F

FP Novice

I would like to create a cell where a user can enter a value (1 thru 4096),
the entered value will jump them to the corresponding row. Can this be done?

or should I simply create a worksheet that performs a lookup to another sheet?
 
F

FP Novice

I found it...just enter the cell you want to go to in the top left corner.

Sorry to bother...
 
K

Kevin B

In addition to the address box you can press the F5 Go To key and specify a
location or select from a list of named ranges.
 
Top