You need an OR, like this?
=IF(Sheet2!$C1=Sheet1!$A1,OR(COUNTIF(Sheet1!$A1:$A3,"yes"),COUNTIF(Sheet1!$B1:$B3,"yes"),"FAIL")
Posted By: trafford_canary, Jan 16, 11:43:18
Follow Ups
Reply to Message
Written & Designed By Ben Graves 1999-2025
=IF(Sheet2!$C1=Sheet1!$A1,OR(COUNTIF(Sheet1!$A1:$A3,"yes"),COUNTIF(Sheet1!$B1:$B3,"yes"),"FAIL")
Posted By: trafford_canary, Jan 16, 11:43:18
Written & Designed By Ben Graves 1999-2025