Come to think of it, you'll probably want to format as a hyperlink.

=IF(D2="","",HYPERLINK("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