=COUNTIF(TESTME,A2)<1
TESTME is a named range on sheet "june11_current" from A2 to A4007, you need to use a named range if using a different sheet (which is what I neglected on the first attempt)