Dependent dropdowns + Output with conditions

Rick187

New Member
Joined
Aug 29, 2018
Messages
12
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.

Thanks in advance.
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

tyija1995

Well-known Member
Joined
Feb 26, 2019
Messages
766
Office Version
  1. 365
Platform
  1. Windows
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
Instead of
="https://"&E3&"-"&E5&"-"&E6
Try:
="https://"&E3&"-"&IF(E5="Not country specific",E4,E5)&"-"&E6
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,108,632
Messages
5,523,994
Members
409,554
Latest member
denistrevisan

This Week's Hot Topics

Top