Hyperlink to cell that contain hyperlink

[Omer_K]

Dear all,

I have a sheet with 2 columns:
1. column with a customer name
2. column of contracts, the cells in the Contracts column are hyperlinks.


I would like to create a different sheet using data validation list with the names of customers - so if I choose a particular customer name the cell next to him will be the link of that customer's contract.


I hope I was clear


Thank you

Omer

 

[Ramballah]

in that cell type =Hyperlink( now you click on the cell you want it to jump to, "in here you type what you want to see in the cell your clicking on for example click here")

 

[Omer_K]

Hey,
I already know and use (a lot) with Hyperlink function,
My intention was that the cell I want to refer to is also hyperlink too - so unfortunately it does not work
I found another creative way ..


thanks anyway