CONDITION BEFORE INDEX AND MATCH

[laj_16]

Hello I'm having a problem with my project. I would like to put a condition where if the gender is female then it will only output in the column of weight and height of the female and if the the gender is male then it will output in the column of weight and height of male.

For this project I have 4 yellow columns which is the age, gender, height, and weight.  If the input age match in any cell in first column then it will compare it height and weight status then output. After that I would like to put a condition base on their gender and just output their result on their respective column.

this is my columns

here's the code I'm using to compute the weight in age of girls :

[#2 · Accepted solution]

ITS ALREADY SOLVED.

=IF(ISNUMBER(SEARCH("F",Z2)),IFS(AC2<=INDEX($B$2:$B$73,MATCH(AA2,$A$2:$A$73,0)),"SUW",
AC2<=INDEX($D$2:$D$73,MATCH(AA2,$A$2:$A$73,0)),"UW",
AC2<=INDEX($F$2:$F$73,MATCH(AA2,$A$2:$A$73,0)),"N",
AC2<=INDEX($G$2:$G$73,MATCH(AA2,$A$2:$A$73,0)),"OW",
AC2>=INDEX($G$2:$G$73,MATCH(AA2,$A$2:$A$73,0)),"OW"),"")