Hi,


a possible formula could be:


=IF(AND('Tab2'!G12<>"",'Tab2'!G12<>"Fully Meets Expectation"),"DOES NOT MEET","DOES MEET")

Hope it's a little help