Applying multiple conditions to return Pass and Fail

[Beagle263]

I'm trying to apply a formula to a range of data to show if something has satisfied different criteria, and I want to return "Pass" and "Fail". A nested IF function doesn't seem to work for me as there are too many conditions.

The Pass Criteria I'm Trying to apply to the data set is below.

Case Number	Passed?
0	>=3
1	>=5
2	>=5
FL	>=5
SB	>=30

Book2
					E	F	G	H	I	J	K	L	M
1
2
3					Name	Case Code	Value	Passed?				Case Code	Criteria
4					amy	1	9.3					0	3
5					steve	0	4.0					1	5
6					jo	3	10.4					2	5
7					jenny	2	3.3					3	5
8					becky	1	5.8					4	5
9					john	FL	6.5					5	5
10					fred	SB	7.6					6	5
11					eric	4	5.2					7	5
12					diane	2	24.4					FL	5
13					paul	5	13.7
14					peter	0	11.8
15					david	0	9.1
Surveyed CBR Tests

 

[Fluff]

Hi & welcome to MrExcel.
How about

Fluff.xlsm
	E	F	G	H	I	J	K	L	M
3	Name	Case Code	Value	Passed?				Case Code	Criteria
4	amy	1	9.3	Yes				0	3
5	steve	0	4	Yes				1	5
6	jo	3	10.4	Yes				2	5
7	jenny	2	3.3	No				3	5
8	becky	1	5.8	Yes				4	5
9	john	FL	6.5	Yes				5	5
10	fred	SB	7.6	No				6	5
11	eric	4	5.2	Yes				7	5
12	diane	2	24.4	Yes				FL	5
13	paul	5	13.7	Yes				SB	30
14	peter	0	11.8	Yes
15	david	0	9.1	Yes
Data

Cell Formulas
Range	Formula
H4:H15	H4	=IF(G4>=XLOOKUP(F4,$L$4:$L$13,$M$4:$M$13),"Yes","No")

 

[Beagle263]

Hi & welcome to MrExcel.
How about

Fluff.xlsm
	E	F	G	H	I	J	K	L	M
3	Name	Case Code	Value	Passed?				Case Code	Criteria
4	amy	1	9.3	Yes				0	3
5	steve	0	4	Yes				1	5
6	jo	3	10.4	Yes				2	5
7	jenny	2	3.3	No				3	5
8	becky	1	5.8	Yes				4	5
9	john	FL	6.5	Yes				5	5
10	fred	SB	7.6	No				6	5
11	eric	4	5.2	Yes				7	5
12	diane	2	24.4	Yes				FL	5
13	paul	5	13.7	Yes				SB	30
14	peter	0	11.8	Yes
15	david	0	9.1	Yes
Data

Cell Formulas
Range	Formula
H4:H15	H4	=IF(G4>=XLOOKUP(F4,$L$4:$L$13,$M$4:$M$13),"Yes","No")

Hi Thank you so much

 

[Fluff]

You're welcome & thanks for the feedback.