Forum Discussion
Solved
CONDITION BEFORE INDEX AND MATCH
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 gend...
- 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"),"")
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"),"")
=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"),"")