Array Substitution Based on Drop Down List

R

Royce Edwards

I have created a drop down list in excel cell A1 which contains a validated
list from cells D1 through D3. The values of D1 through D3 are cat, puppy,
and parrot respectively. Cells E1 through E3 contains hidden values which I
want to substitute later. These values are feline, dog and bird respectively.

So, if the user chooses "cat" from the drop-down, I want to do something
like =CONCATENATION($A1,"http://www.petsite.org/",????????????) that will
result in the cell containing http://www.petsite.org/feline as a hyperlink.
Obviously if the user puppy or parrot the respective entry would be
substituted.

Thanks in advance, Royce
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered drop down list 2
up and down array 5
Drop Down List 7
Best method to populate cell based upon drop down list selection 4
Drop Down List Contains the List Header Row 1
Size of drop down in validation list 2
Drop down list & Time Zones. 2
Drop down list 1

Top