Combo control box configure

**excel122** · 03-30-2009, 12:37 PM

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

**royUK** · 03-30-2009, 12:48 PM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!