+ Reply to Thread
Results 1 to 2 of 2

Lookup from hyper link

  1. 07-12-2013, 11:37 AM #1
    boll55
    boll55 is offline
    Registered User
    Join Date
    08-06-2012
    Location
    Quincy,IL
    MS-Off Ver
    Excel 2003
    Posts
    84

    Lookup from hyper link

    I have a whole list of hyperlinks that are linked to worksheets in my work book. (Close to 2000)

    Is there anyway to create a formula that will look up that worksheet in my workbook and give me selective data?

    Thanks


    http://www.ozgrid.com/forum/showthre...137#post674137

    http://www.mrexcel.com/forum/excel-q...ml#post3518121
    Reply With QuoteRegister To Reply
  2. 07-16-2013, 10:25 AM #2
    hamjam
    hamjam is offline
    Forum Contributor
    Join Date
    01-07-2013
    Location
    south africa
    MS-Off Ver
    Excel 2003-13
    Posts
    210

    Re: Lookup from hyper link

    Hello
    Is the data you need on a static cell ?
    In general, the function is called =HYPERLINK(link_location, [your name for this link])

    You could make up the link_location from a string, based on some criteria you may have (but have not provided)

    Regards
    Most helpful to mark solved items as such (see help for directions). Star ratings are always welcome.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1