=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),Range ... ?

S

sarah

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

Why is this working? QuoteNotes is a range. I'm attempting to search for
cells in this range with the value of cell B3 and hyperlink to it. There's
only one cell with the same value of B3 in the range, as they're all unique
values. It's in the same workbook on a different sheet.


Thank you!

sarah
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),QuoteNotes, 2
Hyperlinks with lookups 0
Fill cells based on the other 3 cells unique combination the value on the target cell 0
Adding cells until they are greater than a lookup cell and returning a value 1
trouble with (complicated) vlookup searching another workbook 2
Word macro that can call cells out of Excel for a find and replace 0
Formula Using Vlookup & Match 3
Can UDF return a customized hyperlink? 3

Top