IF / COUNTIF / Blank cell

C. Perry

I am using the below formula but when my reference sheet has a blank cell the formula returns a Yes. I need for it to return a blank cell.

=IF(COUNTIF({Option Exception Master List}, Account@row) > 0, "Yes", "No")

=Chris Palmer

Hello @C. Perry,

This will populate a "Yes" if there's a blank.

=IF(AND(COUNTIF({Option Exception Master List}, Account@row) > 0, ISBLANK(Account@row) = TRUE), "Yes", "No")

This will populate a blank if there's a blank:

=IF(AND(COUNTIF({Option Exception Master List}, Account@row) > 0, ISBLANK(Account@row) = TRUE), "", "No")

C. Perry

My Account@row sheet is referencing {Option Exception Master List} and if Account@row sheet is on the reference sheet I need it to return Yes and if not no. If the Account@row sheet is blank I need it to return blank. Doe not look like your comments prior will allow this. Can you provide a good formula to do this.