INDIRECT Function for Dependent Dropdown Lists in Excel

[Sakthikumar Chinnasamy]

Hi All,

Good day!!!

In the given excel, if I select the country from Column A, appropriate Name & Location should be popup in List to select from dropdown. I did it for Name but i can't able to do for Location.. Pls help me on this.

Thanks in advance

 

[GraH - Guido]

Hi,
See attached file. Is it like that what you want?

 

[bosco_yip]

Another option using OFFSET() instead of Define Name.

1] A2, DataValidation formula :

=OFFSET($N$2,,,MATCH("zzz",N:N)-1)

2] B2, DataValidation formula :

=OFFSET($N$2,,MATCH($A2,$O$1:$Q$1,0),MATCH("zzz",O:O)-1)

3] C2, DataValidation formula :

=OFFSET($Q$2,,MATCH($A2,$R$1:$T$1,0),MATCH("zzz",R:R)-1)

All copied down

4] See attached file

Regards
Bosco