Hyperlink to a cell, in a different sheet, that cointains a specific taxt

M

manuelcgabriel

Hi,

I need to create a hyperlink from a sheet to another, that must check
if a text appears in a collumn of the 2nd sheet, and if it does it
must cretate the link to where that text appears.

Anyone can help
 
S

Sasa Stankovic

actually, you want excel to find specific text in column?
did you try with find or search function?
 
P

Pete_UK

I put 12 names in A1:A12 of Sheet2. On Sheet1 I used A1 to enter a
name, and put this formula in B1:

=IF(ISERROR(MATCH(A1,Sheet2!A$1:A$12,0)),"",HYPERLINK("[Book1]Sheet2!
A"&MATCH(A1,Sheet2!A$1:A$12,0),"Click to go there"))

I hadn't saved the file so its name was still Book1.

Type a name in A1 and if it is not present in the list on the other
sheet you will get a blank in B1. If it is present, though, you will
see the message "Click to go there". Click on this cell and you will
be taken to the appropriate name in Sheet2.

Hope this helps.

Pete
 
Top