LinkBack URL
About LinkBacks
I have a list of names that I wish to bookmark and have the data accessible with an INDEX, MATCH formula. I can get the names to display but I lose the bookmark. Any input would be appreciated.
Thanks
Jim O
I have a list of names that I wish to bookmark and have the data accessible with an INDEX, MATCH formula. I can get the names to display but I lose the bookmark. Any input would be appreciated.
Thanks
Jim O
Last edited by JO505; 01-18-2013 at 12:44 PM.
not sure what you mean by "book mark" and how you are losing it?
perhaps it would be easier to help you if you uploaded a sample workbook, showing what data you are working with, a few examples of what your expected outcome would be, and how you would arrive at that (remove any confidential info if necessary).
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Fdibbins,
Thanks for your response.
By bookmark I mean setting up a link to a file that you can click on and it will open the selected file. I have done this to the list and ti works fine but I cannot get the format to follow the formula. I have done a similar type of setup with "mailto:" I can set a cell up and have e-mail addresses work using a formula to change the data, but I am at a loss to get it to work with a "bookmark" instead of a "Hyperlink". It may not be possible, I just dont know.
Jim O
you can build this around your index/match...
=HYPERLINK("#"&"'[file-name-and-cell-ref-from-the-index/match")
FDibbins,
I am still having some problems. First I am not positive I am using the correct file address and second I am not clear with the "Hyperlink" formula.
First, where can I look to either copy the address (my first choice) or, view the address to be sure I have it right? So far any place I have looked I can not view the entire address. Further , if the address has blank spaces ,such as, "Smith, George" should it be written as "Smith,_George"?
Second, in your formula I am confused. If my file is located in drive C, folder names, sub folder 1 and then the file name, my understanding is the formula would be =HYPERLINK("#"&"'[C:\folder_names\sub_folder_1\file_name,INDEX(MATCH")
Thanks
Jim O
I think I have the address issue solved but I am still not able to get the Hyperlink to work. This is the formula I have tried, to no avail.
The INDEX, Match part returns the correct data but I cannot get the file to open.
Please Login or Register to view this content.
Jim O
PS
This is the address as it is displayed in the properties menu.
C:\Users\Jim\Documents\Jim Ogier Golf\Customers\SNT League\Allen, John
Last edited by JO505; 01-17-2013 at 06:19 PM. Reason: Added file address for clarity.
For me, the easiest way to find the path to another file (file1), is to open it, then in another file (file2), reference any cell in file1 from file2. close file1, and look at the reference in file2 - that is the path
1st do the index/math part, to make sure you are finding the right data. then, when you have the right data, use =HYPERLINK("#"&"the-info-returned-by-the-index/match")
It's hard for me to write the formula for you, because my pathing will be different. But that part should be easy though.
If you still have a problem, upload the file/s and I will take a look for you
m not sure I have been clear enough. Let me try this approach. I can enter a naem in a cell and then right click on the name, open the hyperlink menu and link a file to the name, this is what I an=m refering to as a "bookmark". That is no problem for me but what I am trying to do is, in another sheet (in the same workbook), use a formula (INDEX, MATCH ?) to find the name and then have the link open the file rather than switch between sheets. I am not looking for data in another file I want to open the entire file. I have an INDEX, MATCH formula that will return the address but I cannot get it to open in the new sheet. I have done this sort of thing with e-mail addresses with no problem but this has me stumped. I hope this helps.
Jim O
self-deleted
Last edited by FDibbins; 01-17-2013 at 09:29 PM.
I dont know why I am having such a problem getting my brain wraped around this but let me try this.
This is an address to a file I am trying to open.
The formula I have tried is as follows. What changes do I nee to make to make it funcutional?Please Login or Register to view this content.
I am not sure what I am missing.Please Login or Register to view this content.
Jim O
The formula should be (Use the HORIZONTAL SCROLL BAR of the Formula, in which I have colored the relevant areas according to the below text)
Formula:
Please Login or Register to view this content.
I believe the Allen, John is a Folder Name
$C$4 - Is your Search Text
T$2:$T$198 - Is where the Search Text's are Present
$U$2:$U$198 - Is where the File Name is Present With File Extension
If T$2:$T$198 have only file name WITHOUT FILE EXTENSION then use your formula like the below to include the file name. Here I mentioned the file extension as .xlsb change it to your FILE EXTENSION
Formula:Please Login or Register to view this content.
In the final C4 reference you can change it to whatever since its just a FRIENDLY NAME which should be used for your easy understanding
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
When you Evaluate Formula on it, what is showing up(step by step, please!)?
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Unless, of course, Sixth's solution worked
Thanks for confirming it
Thanks guys, I hit a block on this 1, so I called in the cavalry lol
It happens, Yesterday I called two threads there lol
I think I finally have the issue resolved.
I could not get the Index, Match formula to work, then I remembered that in another workbook I used a VLookup formula to access e-mail addresses. I tried that and it works.
I still have no clue what I was doing wrong but now it works.
I would like to thank everyone for their time with this, especially FDibbins, and his patience with me and my many senior moments.
Again thanks
Jim O
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks