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
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