IF OR Help

[Alex501]

Hi

I've done a vlookup in 2 columns to match phone numbers and email addresses, returning "Yes" if there is a match. I'm trying to do an IF OR formula to say that if there is a "Yes" in either column then return "Yes" in the new column. My formula is as follows;

=IF(OR(I2="Yes",J2="Yes","Yes","No")

For some reason it's only picking up instances where both columns are "Yes".

What am I doing wrong?

Thanks

 

[Joe4]

You are missing a right parenthesis:

=IF(OR(I2="Yes",J2="Yes"),"Yes","No")

 

[Alex501]

You are missing a right parenthesis:

=IF(OR(I2="Yes",J2="Yes"),"Yes","No")

Hi Joe4

Apologies, i mis-typed when I posted the query - I have added the parenthesis in the equation. As far as I can tell the formula is correct.

 

[Joe4]

That formula will return "Yes" if either of I2 or J2 is "Yes".
It would only return "Yes" is BOTH are "Yes" if you use "AND" instead of "OR".

Make sure that all your values in columns I an J are EXACTLY "Yes", and do not have any extra spaces of characters in them.

 

[Akira181]

If that still doesn't work and you have Excel 2019 or 365, you can use the ifs function.

=IFS(I2="Yes","Yes", J2="Yes","Yes",TRUE,"No")