Enter value in cell based on value combination of two other cells

Good afternoon everyone. I have a spreadsheet I'm writing a macro for. I've come to road block where I need to have text entered in a cell based on the values in two other cells in the same row.

In book2.xls - In column D, I need the name of the servicing facility based off the values in columns P and R.

I've included book3.xls to illustrate the table that I would need to include in the macro. I don't want to have to have an excel table to reference if possible, I'd like it written into the code.


I appreciate your help. Let me know if you need anymore detail.

Thanks!