In cell B$4,$ use a MATCH function nested in an INDEX function to retrieve the Gender that was selected in H$4$:H$5,$ 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 H$4$:H$5.$ 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.