Originally Posted by
DonkeyOte
As I see it there is zero need for Volatile CELL in this instance - this adds unnecessary complexity and calculation overheads to proceedings.
Sheet1!A2: - as before but with adjust B range.
=HYPERLINK("#INDEX(sheet2!B:B,MATCH(100,Sheet2!A:A,0))",100)
Sheet2!B2:
=HYPERLINK("#INDEX(Sheet1!A:A,MATCH("&A2&",Sheet1!A:A,0))",50)
but in these instances as before you're hardwiring the values within the functions which is generally ill advised. You would be better using alternative cells to store the hyperlinks.
If you want to automate the hyperlinks within the cells and without using the hardwired functions I'm afraid you're looking at VBA - and assuming the values in the cells change that in itself will not be entirely trivial (will necessitate event driven code).
Bookmarks