Result Based On 3 Drop Down lists

[achitian]

I am looking at a few formulas duplicated based on a few drop down choices. Please see attached file

Here is what I want done. Please Help me

In Mens Meal Plan sheet
if C2 is Gain Mass and C3 Body Style is Mesomorph and Carb Day is Basic then H3 is = G14 From Men Worksheet

if C2 is Gain Mass and C3 Body Style is Mesomorph and Carb Day is High then H3 is = G17 From Men Worksheet

if C2 is Gain Mass and C3 Body Style is Mesomorph and Carb Day is Moderate then H3 is = G20 From Men Worksheet

if C2 is Gain Mass and C3 Body Style is Mesomorph and Carb Day is Low then H3 is = G23 From Men Worksheet

And so on for all other options. If I can get a formula or macro which I can also to add other options result values too. Thanks

[jindon]

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

[sourabhg98]

Hello

welcome to the forum!

try this formula in H3

=IF(IF(AND(C2="Gain Lean Muscle Mass",C3="Mesomorph"),1,2)=1,IF(C4="Basic",Mens!G14,IF(C4="High",Mens!G17,IF(C4="Moderate",Mens!G20,IF(C4="Low",Mens!G23,"")))),"")

Tell me if it works right….

Hope it helps
Do ask for any other query you may have…

If you are satisfied then mark then PLEASE mark this thread as “SOLVED” (by going to thread tools at the top and clicking on “mark this thread as solved”) and you can just click on ADD REPUTATION below my post to say thanks...

Regards
Sourabh Gupta