Keeping my Hyperlinks

[Dartel]

Hello all,

I am making a spreadsheet to visulize various componants in a
Hometheater setup for price comparing I have made a list of componants and in
the lists they are Hyperlinked to Pricegrabber.com, In the area I put
together the system componants I want togetherI have made dropdown lists for
each componant but when I select one it show just the word from the list and
does not include the hyperlinks I have attatched to them, Is there a way to
keep the hyperlinks of the selection I make from my list?

Edward

[Dave Peterson]

Not using the dropdown.

If you used Data|Validation to create the dropdown and you're showing the link
address, maybe you can use an adjacent cell with a formula:

=if(a1="","",hyperlink("http://" & a1)

or some variation.

The user will have to click on the link in that adjacent cell, though.

Dartel wrote:
>
> Hello all,
>
> I am making a spreadsheet to visulize various componants in a
> Hometheater setup for price comparing I have made a list of componants and in
> the lists they are Hyperlinked to Pricegrabber.com, In the area I put
> together the system componants I want togetherI have made dropdown lists for
> each componant but when I select one it show just the word from the list and
> does not include the hyperlinks I have attatched to them, Is there a way to
> keep the hyperlinks of the selection I make from my list?
>
> Edward

--

Dave Peterson