=IF(INDIRECT("'Lead Data'!G8")<"", IF(MONTH(INDIRECT("'Lead
Data'!G8"))=3,INDIRECT("'Lead Data'!E8"),""), "")
And if you are copying down the formula, use this instead:
=IF(INDIRECT("'Lead Data'!G"&ROW(A1)+7)<"", IF(MONTH(INDIRECT("'Lead
Data'!G"&ROW(A1)+7))=3,INDIRECT("'Lead Data'!E"&ROW(A1)+7),""), "")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---