Thread: scroll to or hyperlink to a cell from a value entered
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default scroll to or hyperlink to a cell from a value entered
=HYPERLINK("#Sheet1!D" &(MATCH(J9,D15:D3014)+14),"go there")

adjust the sheet name to match your sheet name.
--
Gary''s Student - gsnu200789


"Charno" wrote:

I have a list of data in D15:D3014 (no duplicates).
What i want to do if possible is set up a lookup cell (say in J9) so that
when data is entered into cell J9 that matches data in D15:D3014 then the
page will scroll to the matching data or create a hyperlink to the matching
data..........

Reply With QuoteReply With Quote