=IF('Lead Data'!$G8<"", IF(MONTH('Lead Data'!$G8)=3,'Lead Data'!$E8,""), "")

Something like this was meant:
=IF(INDIRECT("'Lead Data'!G8")<"", IF(MONTH(INDIRECT("'Lead
Data'!G8"))=3,INDIRECT("'Lead Data'!E8"),""), "")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Matt" wrote:
Not sure I understand. Here is a sample formula for a cell in Sheet2 that
populates based on what is entered in sheet1:

=IF('Lead Data'!$G8<"", IF(MONTH('Lead Data'!$G8)=3,'Lead Data'!$E8,""), "")

So, it looks at the date in Sheet1 and if the month is a '3' (March), it
pulls the coresponding amount into this cell from E8 of sheet1. If I cut and
paste the above row from sheet1 and move it to Sheet3 named 'Cancelled', the
above formula updates itself and replaces 'Lead Data' with 'Cancelled'.

Does that help?