(Question to answer)In cell B4, use a MATCH nested in an INDEX function to retrieve the Gender that was selected in H4:H5, looking at the x in column H and returning the F or M for the Gender criteria. Using a MATCH nested in an INDEX function, retrieve the gender that was selected in H4:H5. Nest the MATCH and INDEX formula inside the IFERROR function in case the user does not select a specific gender. The IFERROR should leave the cell blank if a gender is not selected.

Cell Ranges below(Class:Enrolled=A3:C3, Report:Class=E3:F3, Report:Gender=H3:I3)

Class	Gender	Enrolled		Report	Class		Report	Gender
S39					Z23		x	F
					J49			M
					Y23
Max Enrollment					A22
Class Type				x	S39
					A39
NOTES					T22
Availability
Number of Instructors
Options