ADDING IF IS BLANK TO EXISTING FORMULA

[meppwc]

I am trying to add to this formula below, that if MAIN!BN2 is a blank cell, then return blank. Currently if BN2 is blank it is returning FALSE.
=COUNTIF('ANALYTICAL TABLES'!A:A,MAIN!BN2)>0

I tried below, but it still keeps returning FALSE opposed to blank
=IF(BN2=",",COUNTIF('ANALYTICAL TABLES'!A:A,MAIN!BN2)>0)

 

[Joe4]

Try it like this (using double-quotes instead of single-quotes and adding "MAIN" in front of the BN2 reference):

=IF(MAIN!BN2="","",COUNTIF('ANALYTICAL TABLES'!A:A,MAIN!BN2)>0)

Note that if you are entering this formula on the MAIN sheet, you do not actually need the "MAIN" sheet reference at all in either place of this formula.

If it still returns FALSE, it means BN2 is not empty (note that a single blank space is NOT the same as empty).

 

[meppwc]

Perfect and thank you

 

[Joe4]

You are welcome.
Glad I was able to help!