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

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

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

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

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