Please help,

I am trying to enter a formula that will find whatever is typed in within
selected cells.

Example: I want the user to be able to type a name or number into a cell and
they will be taken to the location of that cell like with the Find Function
but without having to use that function.

is there a formula to do this?

Many thanks
Charlene
NZ