Drop Down List - Indirect

Dears good afternoon

May I kindly ask if someone can help me regarding the drop down list and the function Indirect.
I have actually in the "Cover" sheet, two lists.

The first one is the countries and the second one, is abbreviation of ports
In a first post a collegue found a solution to filter all sheets through the cover page.
What I need now is to create a second list depending of the choice on the first list.

It means :
If I select Belize I want to see the solution possible for this country in the second list....
The issue I face is, for some countries the function Indirect is not working. (example : puerto Rico, Trinidad And Tobago...)

I created on Sheet 2 lists and named it.
I do not what it is wrong and I am a little bit desperate :D

Once again if someone can help me, will be grateful.
Regards

It will have issues with any country that contains spaces in the wording.

Change the formula in the "Source" for the data validation of cell D4 to the formula below in order to switch the spaces for underscores as per your named ranges.

Formula:

Please Login or Register  to view this content.

BSB

Originally Posted by BadlySpelledBuoy

It will have issues with any country that contains spaces in the wording.

Change the formula in the "Source" for the data validation of cell D4 to the formula below in order to switch the spaces for underscores as per your named ranges.

Formula:

Please Login or Register  to view this content.

BSB

I tried this solution but It did not work.
May I ask you if you can upload excel file with this formula ?

Originally Posted by MarvinP

Hi,

Or simply replace all your country names on Sheet2 that have a space with an underscore. See the attached. The problem is that "El Salvador" needs to be "El_Salvador" to match.

Attachment 575474

Unformtunately, I can put _ in my countries, but I will have to change all countries in each sheet.
If you check your file, you will see that selecting the country os not ding the autofilter in the other sheets.

Thank you guys for your help. If you can help me more IŽll be grateful

Regards

Try this...

BSB

I think it's because you're on a Mac and so you need ; rather than ,

Glad I could help

BSB