I have no idea if or how I can achieve this. Any help will be greatly appreciated.
In cell A1 I have a drop down box. The options in the list are A B C D E F
In cell B1 I have a second drop down box. The options in this list are 1 2 3 4 5 6
In cell C1 I have a third drop down box. The options in this list are U V W X Y Z
On another worksheet I have results that I want to show in D1 depending on which combination has been chosen.
For example if I have chosen C 3 Z I want the corresponding figure on the other worksheet to show in cell D1
But I need to cover each combination in the same formulae.
I hope this makes sense.
Bookmarks