Hello,

I'm working on a spread sheet where we would like to look at current year data (2015) for each month, by linking cells back to already existant workbooks/spreadsheets. When I do a 'Find and Replace' and change "2014" - "2015", my sheet updates for the months that have already passed (January-May), but since we dont have future month spreadsheets already (June-December) created it wont fully update my workbook.

How can I write a formula for excel to look for a spreadsheet (for example, August 2015 Financials -- which hasnt been created yet), and if there is no sheet, return "N/A", but if the sheet does exist (ex. May 2015 Financials) return the specified cell value? I'd like the formula to work so when we do reach the month end and have an August 2015 Financials.xlsx file, it won't have to be re-formulated.

Istthis even possible to do in excel? I can try to reword my problem if there is any confusion.

Please help!!

Thank you!