Dynamic ranges with multiple vlookup

Hello guys!

I need to create a 2-steps selection pane where the user first select the COUNTRY and then the DEALER.

In order not to have blank values in the top-down list, I used dynamic ranges but it doesn't work. Could you please have a look at the file and tell me what's wrong?
TEST.xlsx

Thanks in advace guys.

Hi John! i'm sorry it works also for countries. thx a lot!

But still, could you explain me why did you use a COUNTIF and what's the role of the "*?" ?


Thx in advance

Hello John!

thx a lot, it worked for dealers but not for country. Do you know perhaps why?

Also, why did you use a COUNTIF instead of COUNTA?

Thanks in advance.

COUNTIF with "*?" checks if there any characters in the cell so ignores blanks.

COUNTA checks empty so a space (for example) is NOT empty.