I need an array formula to extract values in the first column if 2 criteria are met

[Banahaw2509]

Perhaps someone here could help me. I've been looking for an array formula that will extract all the names in Column A if 2 criteria are met, one being the Day in a Week listed in the Header, cells B1:H1, and two being the Status in cells B2:H7. If I use WED and Absent as my 2 criteria, the array formula should extract Paul, James and Luke. I really am not so good at this but I think that the array formula will contain the below. Thanks!
index($A$1:$A$7
($B$1:$H$1=$J$1)
($B$2:$H$7=$J$2)

 

[StephenCrump]

Here's one way:

	A	B	C	D	E	F	G	H	I	J	K
1		SUN	MON	TUE	WED	THU	FRI	SAT		WED	Paul
2	John		Absent							Absent	James
3	Peter						Absent				Luke
4	Paul				Absent
5	James			Absent	Absent
6	Luke				Absent
7	Sebastian					Absent
Sheet1

Cell Formulas
Range	Formula
K1:K3	K1	=FILTER(A2:A7,XLOOKUP(J1,B1:H1,B2:H7)=J2,"n/a")
Dynamic array formulas.

 

[Banahaw2509]

Stephen, thank you for your response. My faith in humanity is restored! There are some nice and wonderful people out there, and you are one of them! Thank you for solving this for me, Thank You!