excel

[Lucky1654]

Hello Guys

I am new to this and learning pls help. In multiple dropdowns how to make this work.

Like              Address                                             Apartment no.

           123 NELSON STREET SE                                   A, B, C

            345 CANTON STREET SW                                1, 2, 3

So if you choose 123 nelson street you have to pick an apartment no  A, B OR C

AND IN OTHER ADDRESS FROM 1,2 OR 3.

[#2]

@Lucky1654 

Please check How to make dependent dropdown lists in Excel | Exceljet or google for "Excel dependant drop-down lists", lot of information.

To be more concrete desirably to have sample file.