Hi,
Please see the attached file. In cell D15 I have a drop down for letters and based on the value in D15 I have to show the corresponding letters in drop down in E15.
B C D E F G
4 X X
5 X
6 X X X
7 X
8 X
9 X X X
10 X X X
Letters Numbers
B
For example I select letter 'E' in D15 then in the drop down in E15, it should show the numbers 4 and 10 only and no blank spaces in between or after. Similarly if I select letter 'C' in D15 then in the drop down in E15, it should show the numbers 7 and 9 only. The data for these 2 drop down is from B3 to H10. I do not want to use any macro. I just want to use the excel functions. I am not getting any example like this. I hope I am clear enough in describing about what I am expecting. Can someone please help.
Thanks in advance,
skexcel
Please see the attached file. In cell D15 I have a drop down for letters and based on the value in D15 I have to show the corresponding letters in drop down in E15.
B C D E F G
4 X X
5 X
6 X X X
7 X
8 X
9 X X X
10 X X X
Letters Numbers
B
For example I select letter 'E' in D15 then in the drop down in E15, it should show the numbers 4 and 10 only and no blank spaces in between or after. Similarly if I select letter 'C' in D15 then in the drop down in E15, it should show the numbers 7 and 9 only. The data for these 2 drop down is from B3 to H10. I do not want to use any macro. I just want to use the excel functions. I am not getting any example like this. I hope I am clear enough in describing about what I am expecting. Can someone please help.
Thanks in advance,
skexcel