in O4:
=IF(D2="","","www."&D2&".com")
"tarheelrooster" wrote:
I am looking for a function or a formula to: Cell D2 has a drop down list.
When I chose an item (word) in the drop down list, I wan another cell to show
a web address. Each word in D2 will have a different web adress that shows
up in the other cell (O4). Example: If DOG is in cell D2 I want www.dog.com
in O4. If cat is in cell D2 I want www.cat.com in O4