"Lmurraz" wrote:
My current formula is:-
=MONTH(VLOOKUP(A1,'Y:\EWO Tracking\Mill & DSG\[Mill & DSG EWO
Tracking.xls]Mill'!$1:$65536,7,0))

Try trapping the vlookup's return for zeros, viz something like:
=IF(VLOOKUP(...)=0,"date not found",MONTH(VLOOKUP(...)))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---