Hi!
I have a cascaded dropdown list.
I created a table of hyperlinks for each of the selection to give more information from the other sheets.
Now I need to use VLOOKUP to return the hyperlink for the selection. I tried below:
=HYPERLINK(VLOOKUP(E13,U7:V22,2,0),"Click for More Info")
But its not returning hyperlink saying "can not open specified file".
Can anyone help?
Thanks.
What is the result arrived by Vlookup()?VLOOKUP(E13,U7:V22,2,0)
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
It returns "Click for More Info" with a hyperlink, but does not open.
That was written by Hyperlink() formula, but what I am asking is about the result of Vlookup() formula.Originally Posted by spreadsheets1
Any help is greatly appreciated!
=VLOOKUP(E13,U7:V22,2,0)
Copy the above formula and paste it in your worksheet cell and let us know what result it arrives.
@ SIxthsense: If I use only the VLOOKUP, It is returning the text from the table, it looks like hyperlink, but when clicked, it does not take to the desired location.
I am repeatedly asking you to post that text arrived by Vlookup()
You may be missing the path reference that may be the cause for the error. B'cos Vlookup() may be arriving the file name alone.
Still without any proper input from your end its hard to fix your issue.
I have answered your question in previous post.
Repeating still: It is returning only the desired text from the table, but nor hyperlink.
Thanks Though
But what is the text? - not "What do you want it to be?" Copy and paste the results of the vlookup formula here
Sir,
. Please to upload a File for us
View Pic
http://www.excelforum.com/members/da...ch-a-file.html
http://tinyurl.com/oenwprw
. Please to reduce data to a few lines
. Please to desensitize data if necessary
Thank you
Good Day to you
Alan
'_- Google first, like this _ site:ExcelForum.com Gamut
Use Code Tags: Highlight code; click on the # icon above,
Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
http://www.excelforum.com/the-water-...ml#post4109080
https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks