# Dependent dropdowns + Output with conditions

#### Rick187

##### New Member
Hi,

I have already setup dependent lists for example if in the "Region" drop down in Cell E4 if you select "EMEA" then all EMEA countries will display in the drop down for cell E5.

This is what the data looks like

 (Cell D3) Company (Cell E3) ABC (Cell D4) Region (Cell E4) EMEA (Cell D5) Country (Cell E5) Italy (Cell D6) Name (Cell E6) John (Cell D7) Output (Cell E7) ABC-Italy-John

<tbody>
</tbody>

In Cell E7 I have this formula - ="https://"&E3&"-"&E5&"-"&E6

If a country is selected like "Italy" I only want the output to show the joined up words with dashes in between them so it will be ABC-Italy-John

However if the value in cell E5 contains "Not country specific" then I would like the output to be "ABC-EMEA-John" so instead of including the country, it will include the region in the output. If a country is selected other than "Not country specific" then the output should include the country and not the region such as "ABC-Italy-John"

Does anyone know if this is possible to do please?

Any help would be appreciated.

### Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
You should be able to nest an IF statement into your E7 cell formula, that way you can modify what the text outputs depending on the value of E5
="https://"&E3&"-"&E5&"-"&E6
Try:
="https://"&E3&"-"&IF(E5="Not country specific",E4,E5)&"-"&E6

Last edited:

Replies
2
Views
879
Replies
3
Views
343
Replies
1
Views
335
Replies
16
Views
552
Replies
8
Views
177

### Forum statistics

1,203,491
Messages
6,055,727
Members
444,814
Latest member
AutomateDifficulty

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back