98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses in - Hyperlink
microsoft excel courses in - Hyperlink
Resolved · Low Priority · Version Standard
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.
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.
Fri 4 May 2007, 13:51Trainer Garry said...
RE: hyperlink
need to do more research on this subject
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
Tue 29 May 2007, 09:45Trainer David said...
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
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
Wed 30 May 2007, 09:33Trainer David said...
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
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. |
Excel tip:Turn Function tooltips on and offExcel 2002 (XP) and Excel 2003 have the Function tooltips facility. When you type in a function name followed by a bracket, for example, =IF(, a yellow box appears beside the function name and lists the function's arguments. This is very useful when you can't quite remember the order of a function's arguments or what the arguments actually are! |
