| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),Range ... ?
=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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),QuoteNotes, | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| How do I create a macro to remove path from hyperlink "address"? | Excel Discussion (Misc queries) | |||
| VBA to address first visible cell in Column "D" after filtering | Excel Discussion (Misc queries) | |||
| Excel: "De-activating" an e-mail address cell? | Excel Discussion (Misc queries) | |||
Linear Mode
