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

A formula can't actually move the cursor to another cell - a formula
can only return values. You will need some VBA code to do that.

You could think about using hyperlinks. For example, enter a number
into A1 and then click on B1 where a hyperlink formula will enable you
to jump to the cell indicated by A1 - would this be of interest?

Pete

On Jan 15, 11:37*pm, CHARLENE
wrote:
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

Formulas ONLY return values. You will need a macro to do this. A
worksheet_change event in the sheet code module using vba FIND should be
ideal.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"CHARLENE" wrote in message
...
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