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.