=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