Your use of AND is incorrect

Change your conditional check to: =IF(AND(D59="Synch",K59="No"),now
your VLOOKUP,etc,etc


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=400180