using hyperlinks to find a cell

[Coffee guy]

I am looking to find a way to create a hyperlink (or something similar) that
when chosen will go to another sheet in the workbook and find that cell with
that value in a named range.

For instance - if cell A1 said Joe Smith and when you clicked on cell A1 you
would then go to where Joe Smith was in another sheet in a named range.

The issue is that Joe Smith will not always be in the same cell each time I
run new data. So there needs to be a way to find Joe Smith in the list.

Thanks!

 

[ivano]

I am looking to find a way to create a hyperlink (or something similar) that
when chosen will go to another sheet in the workbook and find that cell with
that value in a named range.

For instance - if cell A1 said Joe Smith and when you clicked on cell A1 you
would then go to where Joe Smith was in another sheet in a named range.

The issue is that Joe Smith will not always be in the same cell each time I
run new data. So there needs to be a way to find Joe Smith in the list.

Thanks!

Hy, Coffee guy

I think you can use:
=HYPERLINK("# Foglio2!B"&MATCH(A1,Foglio2!B:B,0),A1)
to find text in A1 in Foglio2!B:B

ciao ivano