A formula to give different results according to the selected client profile

[SanFranz]

Good morning,

I am trying to create a formula in an Excel sheet that will apply different criteria based on the client profile selected in cell D4 and the score at
I34.


The sheet has several tabs with the same risk rating (low, medium, and high) but different risk scores.

The current formula is designed for Profile A, but I need to modify it so that if Profile B is selected in D4, the risk rating in cell I35 and the recommended action in cell I39 will automatically change according to the parameters of Profile B tab

Moreover, if the selected profile is B, I need to apply a discount of -5 points.

I'm attaching the spreadsheet for reference.

I appreciate any help you can provide.

Best,


Andry

 

[Fluff]

There is no need to remove it.

 

[awoohaw]

The file is ready. I just need the proper formula to reflect some changes. I would appreciate if you could support in someway as I get lost...

If youi have drop box or one drive you can share a document and post the link here.
Another alternative is to post your data in the thread as a table instead of an image. the data in the table can be copied, but the formulas will not. So you need to provide those as well. Indicating the top left cell address of the table is important too.