IF formula help required for multiple combinations

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.