Hello -

In a dropdown box the user selects a state. Using data validation and the
indirect function, a list of approved hotels based on the state appears in a
second dropdown.

My list looks like - Holiday Inn - www.holidayinn.com (the hyperlink is
active)

but, the hyperlink is not active in the dropdown. I'd like it to be active
so the user can click and make the hotel reservation.

Thanks for any help.

Marc