Try:

=HYPERLINK("#Sheet2!"&ADDRESS(INDEX(QuoteNotes,MAT CH(VALUE(B3),
QuoteNotes,FALSE)),COLUMN(QuoteNotes)),"Test")



In article ,
sarah wrote:

=HYPERLINK("#"&CELL("address",
ADDRESS(MATCH(VALUE(B3),QuoteNotes,0),1)),"Test")

What's wrong with this formula? QuoteNotes is a range. I'm attempting to
search for a single cell in that range that has the value of cell B3 (only
one cell in this range does). Then I need to hyperlink to that specific cell
(it's in the same workbook on the second sheet).

Thank you!

sarah