Hi guys,
Need a little bit of help - i need to use this:
=IF(OR(C4="",COUNTIF('CMDB'!R:R,C4)>0),"In CMDB", C4&" missing from CMDB.")
but i want to ignore blanks ... any ideas?

Thanks in advance for your help