Need help with a formula to calculate price based upon 4 different criteria.

I'm trying to create a pricing matrix that will calculate based on 4 separate inputs from the end user. Attached is my example, first tab (SOE) is where the user inputs criteria in B2:B5. I'm struggling with a formula to produce the following:

A price should calculate in cells B9:B12 if the corresponding "request type" in cell B3 is selected. Otherwise the cells should remain blank.
To calculate the price, here's an example of what I'd like to do:

If B3 on the SOE tab = Contact
Then price calculates on the SOE tab in B9.
Price: =B2*Matrix!D2
Also, depending on the value of B5 on the SOE tab, I want to add the value from E2 or F2 from the Matrix tab.
And finally, if the value of B4 on the SOE tab is Med or High, I want to multiple the price by 1.5 for Med and 2 for High.

Try this:

B9 =IF(B$3=LEFT(A9,LEN(A9)-1),(B$2*VLOOKUP(B$3,Matrix!A$2:D$5,4,0)+INDEX(Matrix!E$2:F$5,MATCH(B$3,Matrix!A$2:A$5,0),MATCH(B$5,Matrix!E$1:F$1,0)))*LOOKUP(B$4,{"High","Low","Med"},{2,1,1.5}),"")

Also, check your DV drop downs. They aren't including all possible options.

This is great - thank you so much for the quick response!

Glad we could help. Thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.