Hi

I run Excel 2000

I have a list of names with each one of them having a hyperlink to an email
address.

These all work fine.

What I would like to do is one of two things.

1st Option

Have a drop down list that lets me choose one of the names from the list and
have it retain its hyperlink properties. I tried using data validation but
the names dont retain their hyperlink properties.

2nd Option

Have a formula that is based on an entry to another cell that returns the
name from the list but retains the hyperlink properties.

Example (in cell G1)

=IF(D1="SUPPLIER 1",HYPERLINK(A1))

(I tried this but it dosnt work so it may be that I have the formula wrong)

Can anyone help?


Thanks


John