Hey NBVC do you know why =IF(LOOKUP($A2,Log!$B$2:$B$4,Log!$A$2:$A$4)=B$1,"Yes","No") wouldn't work for this? It seems to error out to 0 for 9/3/2011 but works for the others...