Text and hyperlink in the same cell

[Marc]

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

 

[jamescox]

What appears to be a reasonable solution to your problem may be at

'Excel: Data Validation lists and hyperlinks, target validation, targe
value' (http://tinyurl.com/kn5xjm)

let us know if it worked for you... :Bg