Dependent hyperlinks on Excel?

Hi guys, I am inserting hyperlinks in an excel document (to the internet)

What i want to do is be able to change the hyperlink dependent on another cell's value, if that makes sense.

in other words i want to be able to write:
=HYPERLINK("http:ww.blahblahblah.com/E...
where E2 would be substituted for the value in the cell E2?

Yes, should be easy:

=HYPERLINK( "http://www.blahblahblah.com/" & E2)

Good luck.
.

Tags

　　General - Computers & Internet 　　Software 　　Security 　　Programming & Design 　　Facebook

Related information

How do you create a link between 2 sheets on a spreadsheet in Excel 2003?

Try this: Click the cell you want the link to be in, and type =. Then go to the page you want to link from and click the cell you want and click enter. It should create the formula for you and...

Where can I download a free photo editing programme?

I recommend GIMP, it has many features of Photoshop and costs nothing. GIMP is the GNU Image Manipulation Program. It is a freely distributed piece of software for such tasks as photo retouching...

Which registry cleaner is better?

Reg mechanic sucks and auslogic does absolutely nothing its a lying software but at least they don't charge you. Use a combination of ccleaner, Abexo, and regscrub this will leave your registr...

Is there a better altenative to limewire?

I got bored with limewire too, its fairly crappy now. You can try BearShare, eMule or eDonkey. Like a previous post said, you can use google. Torrents are ever more popullar, you will need a client...

Can I use the today() function in Excel to return the date 1 week ago, or a month ago?

Try using something like Today() - 7 and see what happens Yes I just tried it and it works: =Today()-7 will return 2/20/08

...

How do I know what to delete/uninstall/disable?

Windows needs to be refreshed every few months to run well. Typically I re-install Windows every 6 months. I would not recommend trying to uninstall programs for performance. You won't see ...

Registry cleaner cause problems?

Your registry is a huge database that holds an inventory or location of many files, folders, programs and processes that reside on your computer. This information is often used to to run and locate...

Is this what Vista was like before?

Longhorn 'The greatest operating system that was never released' officially that is. Oh how much better things could have been. LUg.

...