View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max
 
Posts: n/a
Default Help with linked formulas & multiple worksheets

=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
---