I have created a search form in excel using Data Validation and Vlookup What I wan to Know How to do is as follows.

Using a Activ x or form Control Dop Down. How do I Get the Vlook up to recognise the drop down box. and how do I Link the box to the site name source list.

Also my current set up searches and show email address is there a way of making the email address search resuts an actual Hyper link that works..