Dynamic Hyperlink ?

[atxdood]

Hi all,

I'm hoping someone can show me how to write a formula that will generate a hyperlink based on a cell value.

The links pertain to websites about a specific stock. For example, a link to the Company Profile of Apple (AAPL) is:

http://finance.yahoo.com/quote/AAPL/profile?p=AAPL

There are a bunch of different links I have that I would like to update when I type in a different ticker/symbol in another cell. For example, lets say my input cell is B2

I don't know the exact syntax and the following doesn't work but it kind of illustrates my objective:

http://finance.yahoo.com/quote/B2/profile?p=B2

If anyone can show me the formula or structure to use that would be awesome!!

 

[Peter_SSs]

Welcome to the MrExcel board!

With your stock code in B2, in another cell try

=HYPERLINK("http://finance.yahoo.com/quote/"&B2&"/profile?p="&B2)

 

[atxdood]

Awesome! Thank you Peter

 

[Peter_SSs]

Awesome! Thank you Peter

You are very welcome.