Hi,

I have two columns that use formulas to return a True or False answer as Yes or No, I would like a third column to return with True or False depending on weather the first two columns return with both Yes or False if no match.
these are the formulas that return Yes and No

=IF(A2="","",IF(ISERROR(VLOOKUP(B2,Codes!$A$2:$A$18,1,FALSE)),"No","Yes"))
=IF(A2="","",IF(ISERROR(VLOOKUP(N2,Exchanges!$B$1:$B$73,1,FALSE)),"No","Yes"))

then this is as far as i have been able to get with the third colums

=IF((R2=EXACT("Yes","No"))+(S2=EXACT("Yes","No")),TRUE,FALSE)

I cant seem to work out why it wont return as True or False, at the moment it returns everything as FALSE, i have also tried comparing the two but also ran in to problems with this.

Finally, sorry i don't think i can attach the excel sheet due to the information it has in it