vikram
=HYPERLINK(CELL("address",INDEX(Sheet2!$A$1:$A$100 0,MATCH(1,Sheet2!$A$1:$A$1
000,1))),1)
The 1's in MATCH(1, ....)),1)
is the number in the cell. The first one finds the row in sheet2 that
matches and the second one is the "friendly name" of the hyperlink.
--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com
"vikram " wrote in message
...
do we have a way other than this one??
like with excel formuls or something
thanks lot pikus
---
Message posted from http://www.ExcelForum.com/