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

  • Thread starter Thread starter sarah
  • Start date Start date
S

sarah

=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
 
Try:

=HYPERLINK("#Sheet2!"&ADDRESS(INDEX(QuoteNotes,MATCH(VALUE(B3),
QuoteNotes,FALSE)),COLUMN(QuoteNotes)),"Test")
 
Disregard - I misread your intent. Try this instead:

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