I am trying to come up with a formula that will take the values chosen on 2 drop down list to populate a chosen amount on another cell.
Example. Cell C4 you choose whether you are Male or Female. Cell C5, you choose whether you are 19-30, 31-50, or 51+.

Servings Recommended: From there I want cell C12 to fill in As 2 Cups if they choose Female and 19-30
1.5 Cups if they choose Female and 31-50 or 51+
and 2 Cups if they choose Male (no matter the age)


Can someone help me out please??!

Thanks