I have created a table like the following in one of the excel sheets.
1 2 3 4 5
A 10 20 30 40 50
B 15 25 35 45 55
C 2 4 6 8 10
D 6 7 8 9 10

In the other excel sheet I have list boxes where in I can select either "A,B,C, or D" and with the help of other list box in the next row I can select "1,2,3,4 or 5"
Now I created a combo box in my 3rd row and need to write a code through VBA or any way where say for eg, I select "C" and "3", it has to trigger to this table present in the other sheet and present the value "6" whihc is actually corresponding to C and 3.

IS there a way to create this.?
Please suggest.
Thankyou