Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 231
Default =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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,624
Default =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

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,624
Default =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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
How do I create a macro to remove path from hyperlink "address"? Ale Excel Discussion (Misc queries) 7 March 31st 08 06:48 PM
change "true" and "false" to "availble" and "out of stock" inthestands Excel Worksheet Functions 2 July 19th 07 07:05 PM
VBA to address first visible cell in Column "D" after filtering EagleOne Excel Discussion (Misc queries) 2 December 11th 06 06:22 PM
Excel: "De-activating" an e-mail address cell? HowdyPete Excel Discussion (Misc queries) 2 August 17th 06 04:18 PM


All times are GMT +1. The time now is 01:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"