Dear all,

Please help me with below case:

B2 should be drop-down list based on the value in B1.
Example: If Function code is 901, the drop down list should contains 3 values: Warehouse, Transport, QC only.

sy5k.jpg

As we have ~100 function codes, formula with IF that I tried -> Data validation IF(B1="901",901,IF(B1="902",902 …. are not applicable.

I would also prefer to avoid having to create more than 100 name ranges.

I tried http://www.contextures.com/xlDataVal02.html but it didn't works.

Thank you very much.