Great question!

Say we have in C1 thru C6:

cnn
abc
cbs
fox
nbc
bbc

and a data validation pull-down in B1. In A1 enter:
=HYPERLINK("http://www." & B1 & ".com")

So basically the hyperlink is defined by what you pull down.
--
Gary''s Student - gsnu200800


"bgkgmg" wrote:

Can I create a HYPERLINK from a drop-down list?

Thanks
Bobby