I want to create a costing table for when various options are selected in Excel

I have created a table for the price of the different option combinations but want to show the total cost on a simple input table. So I want to select from 3 different option groups in separate columns (venue, time period & support). I have drop down lists for each of choices within these options and the prices associated with each. I want to show the cost if I choose venue option 1 in column C, time period option 2 in Column D and support Option 3 in Column E. I have tried the formula =if(and(C3=I2,D3=K1,E3=J3),K3) which works to give me one cost with one range of selections but how do I add more selections to the Formula. (I moved the 'look up' table onto the same tab so it was easier to read which is why the formula is showing the sheet ref.)