Dependent Dropdown

[Manny Singh]

Hi Excel Masters,

I have attached a list, right side list shows No. of WPS and related Batch No.

On the left side I want to be able to select any WPS and only the batch No. from that list should show up, could you help me with this please.

Cheers, Manny

 

[xlstime]

Hey Manny,

See if this is OK-

Steps-

-Create Name range of batch no based on WPS number
and create name for wpsnumbers
- create dropdown for wpsnumbers
- create dropdown with indirect formula

Hi Excel Masters,

I have attached a list, right side list shows No. of WPS and related Batch No.

On the left side I want to be able to select any WPS and only the batch No. from that list should show up, could you help me with this please.

Cheers, Manny

 

[Manny Singh]

Thanks xlstime, much appreciated.