I have a set of cascading drop down lists and when the last piece of information is selected, I would like to have the named range's information be displayed. The named range will contain all hyperlinks to documents on my server.
Please see the example posted.
Thank you!
Try this.
1. Put this formula where you want the data to start (enter it normally)...
=INDIRECT($C$5)
2. Highlight the next few cells down - including the cell with the formula
3. Press F2 (edit), then press ALT CTRL ENTER, not just enter
It will give you that formula, array entered, for however many cells you highlighted.
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
Thank you for your response. Unfortunately the indirect formula is just giving me "#VALUE". Sorry if this seems trivial, I have just been trying to figure this out for a while now but have been unable to.
Edit:
Still looking to figure this issue out, but not having any luck. I would rather not have to do a set of lookup tables to reference the information. Can anyone think of a macro or some VBA code that can be created?
Last edited by efolsom54; 08-06-2015 at 02:54 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks