If Statement Help

[MrNerd]

I have 3 cells (A,B,C) I am looking pull data from to produce an output. All of the formulas/outputs needs to be within 1 cell/formula to make this work. I am really sorry for the structure I have put this in. I am not sure how else to express it. In the end, I am not sure if this is a IF statement or what.

A (A could be any one of these 5 clients)
Client 1
Client 2
Client 3
Client 4
Client 5

B (B could be any one of these 5 conditions)
Condition 1
Condition 2
Condition 3
Condition 4
Condition 5

C (C could be any one of these 3 options)
Option 1
Option 2
Option 2

Formulas and Output (all of this would need to be included in 1 formula so that any of the outputs will populate)

Client 1 + (Condition 1 OR Condition 2 OR Condition 3) + (Option 1 OR Option 2) = 15

(Client 2 OR Client 3 OR Client 4 OR Client 5) + (Condition 1 OR Condition 2 OR Condition 3) + (Option 1 OR Option 2) = 1

Condition 4 + (Option 1 OR Option 2) = 8

Condition 5 + (Option 2 OR Option 2) = 16

Option 2 = 1000

 

[MrNerd]

Phew. Maybe this?

Book1
	A	B	C	D	E
1	Ticket	Client	Condition	Option	Score
2	1	Client 1	Condition 1	Option 1	15
3	2	Client 2	Condition 2	Option 3	1000
4	3	Client 2	Condition 3	Option 2	1
5	4	Client 1	Condition 2	Option 2	15
6	5	Client 4	Condition 4	Option 2	8
7	6	Client 3	Condition 4	Option 3	1000
8	7	Client 5	Condition 4	Option 3	1000
9	8	Client 1	Condition 5	Option 3	1000
10	9	Client 1	Condition 3	Option 3	1000
11	10	Client 3	Condition 3	Option 3	1000
Sheet2

Cell Formulas
Range	Formula
E2:E11	E2	=IF(AND(B2="Client 1",OR(C2="Condition 1",C2="Condition 2",C2="Condition 3"),OR(D2="Option 1",D2="Option 2")),15,IF(AND(B2<>"Client 1",OR(C2="Condition 1",C2="Condition 2",C2="Condition 3"),D2<>"Option 3"),1,IF(AND(C2="Condition 4",OR(D2="Option 1",D2="Option 2")),8,IF(AND(C2="Condition 5",D2="Option 2"),16,1000))))

If you were able to get this with my "chicken scratch" of an example, I will be forever greatful. Let me check.

 

[MrNerd]

YOU KICK SOME MAJOR BUTT!! Thank you!! I really appreciate your help. If you are ever in KC, MO, let me know. I owe you a coffee.

 

[kweaver]

LOL. Glad it worked for you. Please mark it solved.