"Matt" wrote:
Thanks Max. I'm real close. That formula works great if I indeed move that
lead over to the 'Cancelled' Sheet but if that lead isn't a 'Cancell' (i.e.
remains on Sheet1 with the reference on Sheet2) that formula returns a #REF
error.

Not really sure what's happening over there (it seems ok when tested here) ..
(perhaps the sheet that the formulas' reside in is also being mangled <g,
via deletions of cells/rows/columns eg deletion of col A?, subsequent to the
entry of the formulas)

Try instead in the starting cell, copy down:
=IF(INDIRECT("'Lead Data'!G"&ROWS($DS$30000:DS30000)+7)<"",
IF(MONTH(INDIRECT("'Lead
Data'!G"&ROWS($DS$30000:DS30000)+7))=3,INDIRECT("' Lead
Data'!E"&ROWS($DS$30000:DS30000)+7),""), "")

The incrementer: ROWS($DS$30000:DS30000)+7
returns the same as the previous: ROW(A1)+7
but it should provide much more "leeway" (we shouldn't get #REF! errors)
should there be any subsequent deletions/insertions of cells/rows/columns in
the sheet
(as Cell DS30000 is roughly in the dead centre of the spreadsheet ..)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---