The data in both fields is the same - I think...

If I send you a sample spreadsheet would it help ?



"daddylonglegs" wrote:


What do you have in AMS!$B$4:$B$60000, are they dates? If so try

(TEXT(AMS!$B$4:$B$60000,"yyyymmdd")=Summary!C3)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=524394