 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / May 2008scroll to or hyperlink to a cell from a value entered
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.......... =HYPERLINK("#Sheet1!D" &(MATCH(J9,D15:D3014)+14),"go there") adjust the sheet name to match your sheet name.  SignatureGary''s Student - gsnu200789 > 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.......... Gary .....your a star, Cheers mate Charno > =HYPERLINK("#Sheet1!D" &(MATCH(J9,D15:D3014)+14),"go there") > [quoted text clipped - 5 lines] > > page will scroll to the matching data or create a hyperlink to the matching > > data.......... Sorry: =HYPERLINK("#Sheet1!D" &(MATCH(J9,D15:D3014,0)+14),"go there") instead SignatureGary''s Student - gsnu200789 > 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.......... With J9 reserved for you to enter a value, put this in (say) K9: =IF(J9="","",HYPERLINK("#D"&MATCH(J9,D153:D3014,0)+14,",jump")) The word "jump" will appear in K9 when J9 is not empty - just click on that cell to jump to the appropriate cell in column D. Hope this helps. Pete > 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.......... Sorry, should be D15 not D153. Hope this helps. Pete > With J9 reserved for you to enter a value, put this in (say) K9: > [quoted text clipped - 14 lines] > > - Show quoted text - What can be done if the data is across columns instead of down rows? > Sorry, should be D15 not D153. > [quoted text clipped - 20 lines] > > > > - Show quoted text - You would change the range in the second parameter of the MATCH function to suit your data, and you will probably need to change the 14 to a number appropriate to your layout. It was 14 in this case because the data started in D15. If your data started in H5, for example, the number would be 7 as H is the 8th column. Hope this helps. Pete On May 29, 4:23 pm, uturnabout <uturnab...@discussions.microsoft.com> wrote: > What can be done if the data is across columns instead of down rows? > [quoted text clipped - 24 lines] > > - Show quoted text - |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.