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.

can i please have a responce to my question ASAP as i would like to solve some issue with my report on excell.

need to do more research on this subject

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

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

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

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