not to Index, Aggregate if a value is present, NBA InjuryList

[gtd526]

Hello,
I'm using the following formula to obtain a List of Names (InjuryList!$B$3:$B$216) for a Particular Team (BO$1). Which works.
INDEX(InjuryList!$B$3:$B$200,AGGREGATE(15,6,(ROW(InjuryList!$A$3:$A$200)-ROW(InjuryList!$A$2))/(BO$1=InjuryList!$A$3:$A$200),ROWS(BO$3:BO3)))

I don't want to lookup if a Certain name (InjuryList!$B$3:$B$200) contains the value ("probable") in a certain column (InjuryList!$E:$E) for that name.
This should only leave: Dewayne, Gabe, Omer

Thank you.

NBA.xlsm
	BO
1	MIA
2	8
3	Jimmy Butler
4	Dewayne Dedmon
5	Tyler Herro
6	Victor Oladipo
7	Duncan Robinson
8	Max Strus
9	Gabe Vincent
10	Omer Yurtseven
11	#NUM!
12	#NUM!
13	#NUM!
14	#NUM!
15	#NUM!
Injuries

Cell Formulas
Range	Formula
BO1	BO1	=LOOKUP(2, 1/((COUNTIF($B$1:BO1,Favs!$A$4:$A$33)=0)*(Favs!$A$4:$A$33<>"")),Favs!$A$4:$A$33)
BO2	BO2	=COUNTIF(InjuryList!$A:$A,BO$1)
BO3:BO15	BO3	=INDEX(InjuryList!$B$3:$B$200,AGGREGATE(15,6,(ROW(InjuryList!$A$3:$A$200)-ROW(InjuryList!$A$2))/(BO$1=InjuryList!$A$3:$A$200),ROWS(BO$3:BO3)))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B3:EU15	Cell	contains a blank value	text	NO
B26:B120,B3:B15,G3:G15,L3:L15,Q3:Q15,V3:V15,AA3:AA15,AF3:AF15,AK3:AK15,AP3:AP15,AU3:AU15,AZ3:AZ15,BE3:BE15,BJ3:BJ15,BO3:BO15,BT3:BT15,BY3:BY15,CD3:CD15,CI3:CI15,CN3:CN15,CS3:CS15,CX3:CX15,DC3:DC15,DH3:DH15,DM3:DM15,DR3:DR15,DW3:DW15,EB3:EB15,EG3:EG15	Cell Value	duplicates	text	NO

NBA.xlsm
	B	C	D	E
2	Player	Team	Update	Description
3	John Collins	Atlanta Hawks	12/1/2022	Out (Ankle) - Collins is expected to miss a minimum of two weeks, according to Shams Charania of the Athletic. .
4	Dejounte Murray	Atlanta Hawks	12/8/2022	Out (Ankle) - Murray is expected to miss two weeks with a left ankle sprain, according to Shams Charania of The Athetic.
5	Danilo Gallinari	Boston Celtics	9/2/2022	Out For Season (Knee) - The Celtics announced that Gallinari tore his ACL in his left knee. There is no timetable for his return.
6	Al Horford	Boston Celtics	12/7/2022	Out (Health and safety protocols) - The Celtics placed Horford in the league's health and safety protocols.
7	Robert Williams	Boston Celtics	9/20/2022	Out (Knee) - Williams III underwent a procedure and will need 4-6 weeks to recover, according to Adrian Wojnarowski of ESPN.
8	Nic Claxton	Brooklyn Nets	12/11/2022	Day To Day (Hamstring) - Claxton is questionable for Monday's (Dec. 12) game against Washington.
9	Royce O'Neale	Brooklyn Nets	12/11/2022	Out (Personal) - O'Neale is out for Monday's (Dec. 12) game against Washington.
10	LaMelo Ball	Charlotte Hornets	12/2/2022	Out (Ankle) - Ball is dealing with a Grade 2 ankle sprain. No timetable has been announced for when he might return to action.
11	Gordon Hayward	Charlotte Hornets	11/26/2022	Out (Shoulder) - Hayward is dealing with a shoulder fracture and is out indefinitely, according to Shams Charania of The Athletic.
12	Cody Martin	Charlotte Hornets	11/11/2022	Out (Quad) - Martin has not played since Oct. 19 and no timetable has been announced for his return.
13	Dennis Smith Jr.	Charlotte Hornets	12/2/2022	Out (Ankle) - Smith Jr. has not played since Nov. 23 and no timetable has been announced for his return.
14	Mark Williams	Charlotte Hornets	12/10/2022	Out (Ankle) - Williams is OUT for Sunday's (Dec. 11) game against Philadelphia.
15	Lonzo Ball	Chicago Bulls	9/29/2022	Out (Knee) - Ball is expected to miss at least a few months, according to Shams Charania of The Athletic.
16	Alex Caruso	Chicago Bulls	12/11/2022	Out (Back) - Caruso is out for Sunday's (Dec. 11) game against Atlanta.
17	Kevin Love	Cleveland Cavaliers	12/11/2022	Day To Day (Back) - Love is questionable for Monday's (Dec. 12) game against San Antonio.
18	Donovan Mitchell	Cleveland Cavaliers	12/11/2022	Day To Day (Leg) - Mitchell is questionable for Monday's (Dec. 12) game against San Antonio.
19	Ricky Rubio	Cleveland Cavaliers	10/18/2022	Out (Knee) - Rubio will miss the start of the season as he recovers from a left ACL tear.
20	Dean Wade	Cleveland Cavaliers	12/4/2022	Out (Shoulder) - The Cavaliers announced that Wade has an AC joint sprain and is expected to miss 3-4 weeks
21	Dylan Windler	Cleveland Cavaliers	11/16/2022	Out (Ankle) - The Cavaliers announced that Windler will miss another 4-6 weeks.
22	Luka Dončić	Dallas Mavericks	12/11/2022	Day To Day (Quad) - Doncic is probable for Monday's (Dec. 12) game against Oklahoma City.
23	Josh Green	Dallas Mavericks	12/11/2022	Out (Elbow) - Green is out for Monday's (Dec. 12) game against Oklahoma City.
24	Maxi Kleber	Dallas Mavericks	12/11/2022	Day To Day (Foot) - Kleber is questionable for Monday's (Dec. 12) game against Oklahoma City.
25	Collin Gillespie	Denver Nuggets	10/18/2022	Out (Leg) - The Nuggets announced that Gillespie is out indefinitely after undergoing surgery to repair a lower left leg fracture.
26	Michael Porter Jr.	Denver Nuggets	12/2/2022	Out (Heel) - Nuggets coach Michael Malone said that Porter doesn't have a timeframe for a return.
27	Cade Cunningham	Detroit Pistons	12/5/2022	Out (Shin) - Cunningham is out for Tuesday's (Dec. 6) game and still does not have a timetable for his return.
28	Isaiah Livers	Detroit Pistons	12/11/2022	Out (Shoulder) - Livers is out for Sunday's (Dec. 11) game against the Lakers.
29	Andre Iguodala	Golden State Warriors	10/31/2022	Out (Hip) - Iguodala has yet to make his season debut and the Warriors haven't announced a timeline for his return.
30	Andrew Wiggins	Golden State Warriors	12/11/2022	Day To Day (Adductor) - Wiggins did not play in Saturday's game (Dec. 10) against the Celtics.
31	Jae'Sean Tate	Houston Rockets	11/14/2022	Out (Ankle) - The Rockets announced that Tate will be re-evaluated in two to three weeks.
32	Chris Duarte	Indiana Pacers	11/5/2022	Out (Ankle) - Duarte is expected to miss 4-6 weeks with a grade 2 ankle sprain, according to Adrian Wojnarowski of ESPN.
33	Daniel Theis	Indiana Pacers	11/10/2022	Out (Knee) - Theis underwent surgery and is considered out indefinitely, according to Tony East of WTHR Channel 13 Indianapolis.
34	Norman Powell	Los Angeles Clippers	12/11/2022	Day To Day (Groin) - Powell did not play in Saturday's game (Dec.10) against the Wizards.
35	Wenyen Gabriel	Los Angeles Lakers	12/6/2022	Out (Shoulder) - The Lakers announced that Gabriel will be our for at least a week.
36	Juan Toscano-Anderson	Los Angeles Lakers	12/8/2022	Out (Ankle) - The Lakers announced that Toscano-Anderson will miss about two weeks.
37	Steven Adams	Memphis Grizzlies	12/11/2022	Day To Day (Ankle) - Adams is questionable for Monday's (Dec. 12) game against Atlanta.
38	Desmond Bane	Memphis Grizzlies	12/7/2022	Out (Toe) - The Grizzlies announced that Bane is projected to return in 3-4 weeks.
39	Danny Green	Memphis Grizzlies	6/28/2022	Out (Knee) - The 76ers announced that Green has a torn ACL and LCL in his left knee.
40	Jake LaRavia	Memphis Grizzlies	12/11/2022	Day To Day (Foot) - LaRavia is questionable for Monday's (Dec. 12) game against Atlanta.
41	Ja Morant	Memphis Grizzlies	12/11/2022	Day To Day (Thigh) - Morant is questionable for Monday's (Dec. 12) game against Atlanta.
42	Jimmy Butler	Miami Heat	12/11/2022	Day To Day (Knee) - Butler is probable for Monday's (Dec. 12) game against Indiana.
43	Dewayne Dedmon	Miami Heat	12/11/2022	Day To Day (Foot) - Dedmon is questionable for Monday's (Dec. 12) game against Indiana.
44	Tyler Herro	Miami Heat	12/11/2022	Day To Day (Ankle) - Herro is probable for Monday's (Dec. 12) game against Indiana.
45	Victor Oladipo	Miami Heat	12/11/2022	Day To Day (Knee) - Oladipo is probable for Monday's (Dec. 12) game against Indiana.
46	Duncan Robinson	Miami Heat	12/11/2022	Day To Day (Ankle) - Robinson is probable for Monday's (Dec. 12) game against Indiana.
47	Max Strus	Miami Heat	12/11/2022	Day To Day (Shoulder) - Strus is probable for Monday's (Dec. 12) game against Indiana.
48	Gabe Vincent	Miami Heat	12/11/2022	Out (Knee) - Vincent is out for Monday's (Dec. 12) game against Indiana.
49	Omer Yurtseven	Miami Heat	11/15/2022	Out (Ankle) - The Heat announced that Yurtseven underwent surgery and will be re-evaluated at a later date.
50	Joe Ingles	Milwaukee Bucks	9/25/2022	Out (Knee) - Bucks GM Jon Horst said Ingles is expected to return sometime in January.
51	Wesley Matthews	Milwaukee Bucks	12/7/2022	Out (Health and safety protocols) - The Bucks placed Matthews in the league's health and safety protocols.
InjuryList

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B3:E993	Expression	=SEARCH("probable",$E3)>0	text	NO
B3:E993	Expression	=SEARCH("questionable",$E3)>0	text	NO
B3:E993	Expression	=SEARCH("indefinitely",$E3)>0	text	NO
B3:E993	Expression	=SEARCH("Out For Season",$E3)>0	text	NO

 

[Fluff]

How about

=INDEX(InjuryList!$B$3:$B$200,AGGREGATE(15,6,(ROW(InjuryList!$A$3:$A$200)-ROW(InjuryList!$A$2))/(BO$1=InjuryList!$A$3:$A$200)/(ISERROR(SEARCH("Probable",InjuryList!$E$3:$E$200))),ROWS(BO$3:BO3)))

 

[gtd526]

How about

=INDEX(InjuryList!$B$3:$B$200,AGGREGATE(15,6,(ROW(InjuryList!$A$3:$A$200)-ROW(InjuryList!$A$2))/(BO$1=InjuryList!$A$3:$A$200)/(ISERROR(SEARCH("Probable",InjuryList!$E$3:$E$200))),ROWS(BO$3:BO3)))

Perfect. Thank you.

 

[Fluff]

You're welcome & thanks for the feedback.