Hi,

I'm currently having to work on a financial year calendar, as a result my data chart goes upto March 2013. I have a data sheet with sales figures on it and the front sheet and graph pull the figures from there. I've done a simple front sheet cell A1 = data file sheet A1 - the problem is I've copied that formula across the full year and in all the months there is no data it returns a '0' - Is there a way around this ? The lookup formula for a cell that should return a blank but is returning a '0' is =[V2.xlsm]PMM!E$88

Any help would be gratefully received.(using 2007)