I am trying to select either of the last two columns dependent on the
selection of the first two columns. The only way i have been able to do
it is by concenating the first two strings and then doing a look up.

Is there a better way to achieve this. Have struggled with Index and
match with no success.

User will select a Region
then Select a Sum Insured
then Select a Cover type ( AD or DE)
And have the Premium returned

Table sample below:


Region SumIns AD DE
Northwest $180,000 $685.46 $891.09
Northwest $185,000 $696.90 $905.98
Northwest $190,000 $708.09 $920.52
Northwest $195,000 $719.02 $934.73
Northwest $200,000 $729.70 $948.61
Northwest Coast $30,000.00 $232.66 $302.46
Northwest Coast $35,000.00 $257.34 $334.54
Northwest Coast $40,000.00 $281.56 $366.02
Northwest Coast $45,000.00 $305.32 $396.91


Any suggestions or hints appreciated.

Jeff