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)

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