If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Array Substitution Based on Drop Down List
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 |
#2
|
|||
|
|||
Array Substitution Based on Drop Down List
Try this...
Use cell B1 as the hyperlink. Enter this formula in B1: =IF(A1="","",HYPERLINK("http://www.petsite.org/"&VLOOKUP(A1,D1:E3,2,0))) -- Biff Microsoft Excel MVP "Royce Edwards" Royce wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|