Help : Multi criteria with MATCH or LOOKUP formula

What formula should I put in NUTRISTATUS column. That will search value in the table of MALE BMI and FEMALE BMI.
for example when I input data M(male) in ***(gender), age in M(m0nth) and BMI it will search in MALE BMI table..
and I input data F(female) in ***(gender), age inM(month) and BMI it will serach in FEMALE BMI table.
and if the criteria match will appear the word SEVERLY UNDERWEIGHT or OVERWEIGHT or UNDERWEIGHT or NORMAL or OBESE in NUTRISTATUS Column..
here is my sample program..

Originally Posted by Fotis1991

I suggest to take some minutes to read forum rules before to post again. If you have to change your title you go to your first post. Click>>Edit Post>>Go advanced and change your title. No nned to create duplicate threads as it is aginst forum rules.

Just for this time i'll close your other thread and you can continue on this one.

--- thanks for the reminder

Originally Posted by martindwilson

merged cells are a pain but this should work in J4
=INDEX({"Severely Underweight","Underweight","Underweight","Normal","Normal","Overweight","Overweight","Obese"},MATCH(D4,INDEX(IF(C4="m",$C$14:$J$185,$M$14:$T$185),MATCH(ROUND(G4,0),IF(C4="m",$B$14:$B$185,$L$14:$L$185),0),0),1))

-- Thank you so much sir, your formula is working but i change D4 to I4(BMI column or I column). thanks sir i will study this formula..