Document not found!

  • Thread starter Thread starter ianripping
  • Start date Start date
I

ianripping

I have a spreadsheet which looks at several months worth of data.

Each month has its own workbook for 5 different things. Therefore ther
are 5 new files every month about 5 different things.

My master sheet collates all the information from these files. BUT fo
the months which don't exist yet I get the annoying message of Exce
cannot fid this file, because that month hasn't occured yet and s
those files dont exist.] Eg File Name "January 04.xls".

Is there a way that I can get Excel to just display a 0 if the fil
cannot be found or just not display anything at all in that cell whic
links to the missing file?

I know this is a bit long whinded but if you dont understand any aspec
of the question, then please just ask.

Regards

Ian Rippin
 
You could enclose your formula in a if & iserror like so
=IF(ISERROR(your formula here)),0,VLOOKUP(your formula here))
If you want a blank instead of a 0 replace the 0 with ""
Hope that helps,
Barbara
 
Back
Top