flapjack71
New Member
- Joined
- May 8, 2020
- Messages
- 2
- Office Version
- 2016
- Platform
- Windows
I am trying to determine the best way to pull the correct data to a cell if multiple conditions are met. In the attached I tried using the IF AND formula to pull the correct data to E2 based on the values inside A2-D2, all of which have multiple drop down options. I thought I was on the right track since I got it to work in one instance, but I am unsure how to add the others. I'm thinking maybe a different formula is needed here?? Any assistance is appreciated!
=IF(AND(A2="YELLOW",B2="1/2IN",C2="END-BEHIND",D2="END-BEHIND"),N2)
=IF(AND(A2="YELLOW",B2="1/2IN",C2="END-BEHIND",D2="END-BEHIND"),N2)