Hello,

I am trying to create a function that will allow a different hyperlink
to appear depending upon what piece of data is entered into a specefied
cell.

....for instance if I were to type "google" into cell A1 I would then
have a hyperlink to www.google.com created in cell A2.

I have hundereds of different possible hyperlinks and I think that the
ideal way to do this is using a macro but I am not quite sure.

Thanks for any assistance.

What you need is a large Whiskey
No need for macros

=HYPERLINK("http://"&A1&".com","www."&A1&".com")

in A2, I would probably use just

=HYPERLINK("http://"&A1&".com",A1)

if I were you



--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


wrote in message
oups.com...
Hello,

I am trying to create a function that will allow a different hyperlink
to appear depending upon what piece of data is entered into a specefied
cell.

...for instance if I were to type "google" into cell A1 I would then
have a hyperlink to www.google.com created in cell A2.

I have hundereds of different possible hyperlinks and I think that the
ideal way to do this is using a macro but I am not quite sure.

Thanks for any assistance.

A large whiskey is right. =)

I don't think that I phrased the question very well though.

My exact purpose is this...

I have to take subproject names like I815, Y332, X872, etc. The
subproject is one of several items to be listed in the worksheet. What
I need to have happen is, everytime the subproject file is listed in
that column, I need the hyperlink to pull data from a file folder that
has more detailed information about that subproject i.e. phone numbers,
addresses, etc.

I know how to create the hyperlink to pull the data but I don't quite
understand how to make this hyperlink populate when the corresponding
subproject name has been entered into the cell.

Example:

A B C D
1 I815 2456 Vacant ?
2 X872 8954 Occupied ?
3 I815 7652 Occupied ?

---So what do I need to put in these cells to allow a hyperlink to pull
data for the correct subproject?

Sorry I didn't go into more detail to begin with.


Peo Sjoblom wrote:
What you need is a large Whiskey
No need for macros

=HYPERLINK("http://"&A1&".com","www."&A1&".com")

in A2, I would probably use just

=HYPERLINK("http://"&A1&".com",A1)

if I were you



--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


wrote in message
oups.com...
Hello,

I am trying to create a function that will allow a different hyperlink
to appear depending upon what piece of data is entered into a specefied
cell.

...for instance if I were to type "google" into cell A1 I would then
have a hyperlink to www.google.com created in cell A2.

I have hundereds of different possible hyperlinks and I think that the
ideal way to do this is using a macro but I am not quite sure.

Thanks for any assistance.