Formula to Populate list box with values based on a dropdown data control

[mehman]

Hi,

I wish to populate a list box (with blue border in the attached file) based on the value selected in the dropdown(in D4, in the attached file).

For e.g. if I select Sector from the dropdown, I should get the following values in the list box:- (All), Sec1, Sec2, Sec3, Sec4, Sec5

I wish to do this without using VBA. I have attached a sample file.

Thanks in advance.
Mandeep

 

[Somendra Misra]

Hi,

See the file.

Regards,

 

[mehman]

Hi Somendra,

Thanks for the reply. I still have one issue. For some selections, there are blanks rows in the list box. Is it possible to avoid them?

Regards
Mandeep

 

[Somendra Misra]

Hi,

Instead of embeded can you use form control list box?

Regards,

 

[mehman]

Hi,

How do I do that?

Regards

 

[Somendra Misra]

Select the one shown in below pic.



Right Click on the control, select Format control and fill the required Values. In Input range give the named formula defined earlier.

Regards,

 

[mehman]

Thanks

 

[Somendra Misra]

Welcome back anytime!!!

Regards,