go to a cell without using F5

[still learning]

Hi

I use the following if statement to find the cell number of results of an advance filter. I got the statement from this site as a reply, THANK YOU

=IF(BA3="","",@CELL("address",INDEX($A$3:$C$1988,MATCH(BA3,$A$3:$A$1989,1),0)))

It returns a cell number like:

$A$225

I was wondering if it would be possible to then just click on the cell with that $A$225 and go to it instead for having to press F5 and typing in the address .

Mike

 

[Rick Rothstein]

Not quite as automatic as you are looking for, but... select the cell with the address and press CTRL+C (copies it into the Clipboard), then click in the Name Box (next to the Formula Bar) and press CTRL+V (pastes the copied address) and press the Enter Key.

 

[Fluff]

How about

=IF(BA3="","",HYPERLINK("#"&CELL("address",INDEX($A$3:$C$1988,MATCH(BA3,$A$3:$A$1989,1),0))))

 

[still learning]

Hi Fluff
Wow...works great but would there be a way to have it scroll up after it goes the the hyperlink since it finds the cell and shows it at the bottom of sheet.
Hi Rick

mike

 

[Fluff]

Probably not.

 

[still learning]

thanks

mike

 

[Fluff]

Glad we could help & thanks for the feedback.