Hi,
I have a table which allow me to select a value based on variableX and variableY. I attached a simple table below in case any confusions.
So, I made an userform with two different combobox for variableX and variableY.
My question is this, how could i use the value from the 2 different combobox selection to return the value. (assuming the table is not in the worksheet)
Please help
I have a table which allow me to select a value based on variableX and variableY. I attached a simple table below in case any confusions.
So, I made an userform with two different combobox for variableX and variableY.
My question is this, how could i use the value from the 2 different combobox selection to return the value. (assuming the table is not in the worksheet)
| variable y-2 | variable y-2 | variable y-3 | |
| variable x-1 | 1 | 4 | 7 |
| variable x-2 | 2 | 5 | 8 |
| variable x-3 | 3 | 6 | 9 |
Please help