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