If Statement with Multiple Conditions

[abbeyrd237]

Hello,

I'm trying to find the best formula where it will return Column D (Name) if it meets all 3 conditions (Column A,B and C). For example, If Jan 2020 Too small, return Jane Doe. Also return a blank if false. Thank you!

Column A Column B Column C Column D
Jan 2020 Too small Jane Doe
Feb 2020 Too big John Doe
Mar 2019 Too small Jim Doe

 

[mikerickson]

What three conditions?
Also what values are in which column
Is "Jan" in A2, 2020 in B2, "Too" in C2 or some other division?

 

[abbeyrd237]

Yes
Jan is in Column A
2020 is in Column B
Too small / big in Column C
Name in Column D

 

[cortexnotion]

@abbeyrd237 your explanation suggest you are looking for a different formula for rows 2, 3 and 4 but I suspect you actually want something to apply equally to all rows. Please confirm?

 

[abbeyrd237]

This is the sample data. I wanted to use a formula where it returns the name of the person if it meets all 3 conditions (Month, Year and Reason). Example, If Jan 2020 Too small, return John & Alice and any other names that meet these conditions. But if not a match, return a blank.

 

[abbeyrd237]

Under the column named Return, looking for a formula that can return the name or leave a blank if conditions not met

 

[mikerickson]

Try =IF(A2="Jan", B2=2020, C2="Too Small", D2, "")

 

[abbeyrd237]

Thank you, Unfortunately I'm seeing this error message.

 

[abbeyrd237]

=IF(A2="Jan", IF( B2=2020, IF( C2="Too Small", D2, "")))
This formula seems to work but it still returns FALSE if the condition isn't met. Not sure why it won't return a blank?

 

[mikerickson]

Sorry, this is what I was thinking.
Try =IF(AND(A2="Jan", B2=2020, C2="Too Small"), D2, "")