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.
Bookmarks