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

=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

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

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

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

Disregard - I misread your intent. Try this instead:

=HYPERLINK("#Sheet2!"&ADDRESS(ROW(QuoteNotes) +
MATCH(B3,QuoteNotes,FALSE)-1,COLUMN(QuoteNotes)),"Test")


In article ,
JE McGimpsey wrote:

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