How - Match/If/Countif

**Shermaine2010** · 03-31-2013, 11:11 AM

tigertiger - your formula is applicable but I would like to show "Check" or "Check- Date".

**tigertiger** · 03-31-2013, 11:57 AM

Originally Posted by Shermaine2010

tigertiger - your formula is applicable but I would like to show "Check" or "Check- Date".

if that, you use the formula for C15
=IF(COUNTIF($A$5:$A$6,A15)>0,IF(B15=LOOKUP(A15,$A$5:$A$6,$B$5:$B$6),TRUE,"Check"),IF(B15=$B$1,TRUE,"Check-Date"))
copy down for C16,C17,...etc

one time again:
However, plz, you 'd mention about all cell containing date data --- All cells that , except cell B1, contain date as text (not date type) - cause the failure result

**Shermaine2010** · 03-31-2013, 09:30 PM

Originally Posted by tigertiger

if that, you use the formula for C15
=IF(COUNTIF($A$5:$A$6,A15)>0,IF(B15=LOOKUP(A15,$A$5:$A$6,$B$5:$B$6),TRUE,"Check"),IF(B15=$B$1,TRUE,"Check-Date"))
copy down for C16,C17,...etc

one time again:
However, plz, you 'd mention about all cell containing date data --- All cells that , except cell B1, contain date as text (not date type) - cause the failure result

Thanks. Also thanks for the reminder. I am aware that B1 is date format. I use formula to change it. Thanks