vlookup results providing multiple hyperlinks in the same cell

  • I am trying to create a worksheet, that references word documents in the same cell with vlookup responses for more info.


    Example:
    (the items are in a validation list)



    { item a } { item a's basic summary } { link to word.doc with full item a info. }



    { item b } { item b's basic summary } { link to word.doc with full item b info. }


    When I select item b from the list, I'm trying to make it so it's summary will be shown, and in another cell next to it, a hyperlink will take you to the item b word.doc.


    Using the same cells, when I select item a, I'm trying to get item a's summary, and in the same cell as the one used by item b's hyperlink, I would like it to change to match item a's info.


    I'm relatively new to Excel, and I've been frustratingly stuck on this for awhile. I searched the forums, so I hope this isn't a repeat question.


    Thank you for yor assistance!!


    xmortal

  • Re: vlookup results providing multiple hyperlinks in the same cell


    Here is an example file


    (You will of course need 3 documents called


    summarya.do
    summaryb.doc
    summaryc.doc


    in a folder called C:\Will


    The formula used was


    =HYPERLINK(path&"\"&B2&".doc",B2)


    the named range path contains C:\Will


    B2 contains summaryb and is the result of a formula


    =VLOOKUP(A2,K1:L3,2,FALSE)


    Where A2 contained Itemb


    and K1:L3 was a simple lookup table


    See the file

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!