Using two IF AND statements for two conditions each

[BeadyBob]

Hello,
I am trying to pull a result that has two conditions but I need it to do this twice based on what value is found in the first condition.
If C4 is the same as R8 and M7 has Henderson listed, pull R12, otherwise pull W12.
If C4 instead is the same as T8 and M7 has Henderson listed, pull T12, otherwise pull Y12

=IF(AND($C$4=$R$8,$M$7="Henderson"),R12,W12,(if(AND($C$4=$T$8,$M$7="Henderson"),T12,Y12)))

It's not working. If there is a fix to this formula or a suggestion for a better formula, I would really appreciate the help.
Thanks so much.

 

[Alex Blakenburg]

What do you want to happen if:
1) C4 = R8 and C4 = T8 (both are true)
2) C4 <> R8 and C4 <> T8 (both are false)

 

[BeadyBob]

Thank you for asking. I may be trying to do something that can't be done. Within the same formula (same cell for result) I am trying to.

1) C4 = R8 and M7 = Henderson (both are true) return R12 (if first criteria true but second is not return W12)
2) C4 = T8 and M7 = Henderson (both are true) return T12 (if first criteria true but second is not return Y12)

 

[Alex Blakenburg]

I understood that but you didn't answer my questions. Unless you want to concatenate or sum results, you can't put both R12 AND T12 in the same cell (both true) or W12 AND Y12 in the same cell (both false)

 

[BeadyBob]

I see, apologies. I do not want to sum the results, they are an either one but not both.

I did not explain that C4 is a drop down where one of two choices will be selected.
Depending on which choice is selected it will change which column the result is pulled from. (result column headers include the name of the C4 dropdown)
M7 is also a dropdown with two choices. Henderson is one choice. (result column headers do no include the name of the M7 dropdown)

Thank you for your time. I do understand if this is not a logical or achievable.

 

[Alex Blakenburg]

Combining the info from your 2 posts, see if this works for you:

=IF($C$4=$R$8,
      IF($M$7="Henderson",R12,W12),
      IF($C$4=$T$8,
        IF($M$7="Henderson",T12,Y12),
        ""))

 

[BeadyBob]

My goodness, that works beautifully. Thank you so much Alex, you untangled my confused formula and made it look easy.

 

[Alex Blakenburg]

I find it easier to follow the logic if you use Alt+enter to split it across lines and spaces to indent. Glad I could help.