Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses in - Hyperlink
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
microsoft excel courses in - Hyperlink
Resolved · Low Priority · Version Standard
Reply Thu 15 Mar 2007, 12:08Delegate Gunaratnam said...
Gunaratnam has attended:
No courses
Hyperlink
how can i do a "IF" function or "Vlookup" that includes a hyperlink in it.
for example have set up mu hyperlink on a seperate tab for different customers which is picking up the information for that customer.
now on a sepreate sheet i want to do a "IF" sum that will look up the hyperlink for the relevent custome.
i have tried the formula "=hyperlink(vlookup(a1,A:C,2,false))
but this is coming up with error message.
can you please help.
For upcoming training course dates see: Pricing & availability
Reply Tue 27 Mar 2007, 17:20Delegate Gunaratnam said...
RE: hyperlink
can i please have a responce to my question ASAP as i would like to solve some issue with my report on excell.
RE: hyperlink
need to do more research on this subject
Reply Fri 4 May 2007, 14:28Delegate Gunaratnam said...
RE: hyperlink
i sitll not have a reply (solution) my question and i have reminded them of the fact that i have not had a reply and still not heard anything from them. May be you can help by pointing this out to them
Thnaks
RE: hyperlink
Hi Gunaratnam
Sorry for the delay in getting back to you, it did take a little time to replicate the error that you were getting, so that we could come up with a solution.
What you need to do is to specify the hyperlink that you want to link to i.e.
hyperlink="youlink",vlookup(a1,A:C,2,false)
Hope this helps
David
Reply Tue 29 May 2007, 15:41Delegate Gunaratnam said...
RE: hyperlink
can you be a bit more specific as i tried what you have sugested i still am not able to get the required result, sorry for the inconveniance
RE: hyperlink
Please just make sure that you have replaced where I have written yourlink to the hyperlink that you actually need to use, as when this was tested it did work. Also if you could provide details of the error message you recieve.
Thanks
David
|