Mission Impossible??

[Aikisteve]

Im trying to get excel to use one of 18 hyperlinks depending on what is in another box. I tried a lookup formula but obviously that only shows the text, not a link. Im stuck and my brain hurts, anyone shed any light.

Oh also i have a macro set up to add the date/time something was added, is it possible to run two macros in the same sheet? as i need one for when it is closed.

[Dav]

If the test is the correct path, you are nearly there!

You will kick yourself

=HYPERLINK(VLOOKUP(D2,F2:G3,2,FALSE))


just put your lookupfunction inside a hyperlink, something like the above

Regards

Dav

[Aikisteve]

Hi Dav,

I tried this and i just keep getting #N/A

Could this be because im trying to get a link that is on another worksheet. i have tried inserting the name of the sheet

[Aikisteve]

Sorry, spotted my mistake, you are right,m i am kicking myself