What you need to use is VLOOKUP.
You will need to create a list of all the possible words that can be entered
in D2, with the relevant web addresses next to it. I would name this range
Websites, or something similar.

Say you create this list in Sheet2, from A2:Bwhatever. Now, in O2, enter
the following formula:

=IF(D2="","",IF(ISERROR(VLOOKUP(D2,Websites,2,0)," Unknown",VLOOKUP(D2,Websites,2,0)))

You could of course use Data Validation in D2, to restrict input to only
those values contained in Sheet2!A2:Bwhatever, in which case you can remove
the second IF in the above formula.

--
HTH

Kassie

Replace xxx with hotmail


"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