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

 

[SanjayGMusafir]

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

Nothing is visible in your screenshot but from what I understand from your query create a table for various profile and variables accordingly.

Then use that table to lookup values as per the profile chosen.

This shall kind of automate your process.

Hope it helps

 

[SanFranz]

Nothing is visible in your screenshot but from what I understand from your query create a table for various profile and variables accordingly.

Then use that table to lookup values as per the profile chosen.

This shall kind of automate your process.

Hope it helps

unfortunately, I cannot use XL 2BB. Could I upload the excel spreadsheet instead?

 

[SanjayGMusafir]

I already gave you a solution to try.

 

[SanFranz]

I already gave you a solution to try.

yes but I cannot manage

 

[SanjayGMusafir]

yes but I cannot manage

We can only give you an idea to work. Can't create a file for you.

 

[SanFranz]

We can only give you an idea to work. Can't create a file for you.

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...

 

[SanjayGMusafir]

I just need the proper formula to reflect some changes

This is at best to give you an idea. Check this and revert -

Book1
	A	B	C	D	E	F	G	H
1	ID	A				ID	Info 1	Info 2
2						A	1234	ABCDE
3	Info 1	1234	Info 2	ABCDE		B	2345	BCDEF
4						C	3456	DEFGH
5
Sheet1

Cell Formulas
Range	Formula
B3	B3	=LOOKUP(B1,F1:F4,G1:G4)
D3	D3	=LOOKUP(B1,F1:F4,H1:H4)

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Formula that gives different results according to the selected client profile
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[SanFranz]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Formula that gives different results according to the selected client profile
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Ok could you please remove this post?
Thank you