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.
As we have ~100 function codes, formular with IF that I tried -> Data validation IF(B1="901",901,IF(B1="902",902 …. are not applicable.
I tried Excel Data Validation -- Dependent Lists but it didn't works.
Thank you very much.
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.

As we have ~100 function codes, formular with IF that I tried -> Data validation IF(B1="901",901,IF(B1="902",902 …. are not applicable.
I tried Excel Data Validation -- Dependent Lists but it didn't works.
Thank you very much.