Excel if statement for dropdown list
Posted on 2014-08-29
i have a dropdown list with different email suffixes like in cell B15
in cell B20 i have also a dropdown with changes different parameters depends on the values i can choose there GUL,GAL,TEST,GIL,DAL. Now i like to include a if statement in the suffixlist above depends on the value in C20
which should automatically change to the correct email suffix in B15.
Thanks in advance