try this:
create a lookup list in your worsheet that has the values to find: this one
is in x1:y2

X Y
dog www.dog.com
cat www.cat.com

then in O4, you will put the formula: =vlookup(d2,x1:y2),2)



"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