Case Statements and If Statements

Hello and thank you in advance for any help!

I am compiling a dataset from 2 databases. One of the databases exports a data field "A". The other exports a data field as the product of "A" and a payment rate. I am trying to have the final dataset only report "A", so I need to divide "A" out of the field that is the product of "A" and the payment rate.
The payment rate is based on 4 primary categories:

Region = North, South
Program = Solar, Wind, Hydro, Solar Thermal
Category = Residential, Small Business, Public, Agriculture
Step = 1,2,3,4,5,6,7,8,9

I have set up a table that has the Step in a column, and the other descriptors in the rows. I was able to create a nested If statement formula and copy/paste it down the column for some of the combinations, but am limited by the number of If statements. So, I am trying to use VBA to divide the value in column 12 (the product of "A" and the payment rate) by the payment rate to obtain "A", based on which combination of descriptors describes the project.

Below is a sample of the road I was trying to go down, without initial success. Again, any help is GREATLY appreciated!

Please Login or Register  to view this content.

Thanks, JM

Thanks xladept, now I get a Run-time error 1004: Application-defined or object-defined error.

I cleaned up the "mergeprocess" to "mergeprocess!$p$6:$u$19", as it is the table range used for the vlookup. That table is in a different worksheet named "mergeprocess".
In this case, the residential and small business cases are the same, so I'll combine.
Thanks.

Is mixing reference styles not allowed?

9-4-12_HelpRequest.xlsm
Okay, I'll clean that up as well. Thank you all so much!!
I've attached a sample of some of the data and the vba for your review.

Column B, in this instance, is used to determine whether or not a specific project "i" has been granted a variance that would show up on the SchoolsPetition table. If it has, then that is the number to be used instead of the calculated cap.

I hope that makes sense, and I really appreciate the help.

JosephP, I think this puts me on the right track, so I'll keep developing to cover all combinations.
A couple of questions though before I start.

First, how does the code you provided know which workbook/worksheet to act upon? (Probably one of the most basic questions you'll be asked, but as advertised, I am quite new to this)

Second, for the other programs, do I just need to follow with "ElseIf" statements for each program and follow your lead on the ensuing case statements? Then, an "Else" for the other Utility and the same process for the other programs under that utility?

Finally, thank you so much again for all your help! I am astounded at the skills of the people on this forum and greatly appreciative!!