I have 3 spreadsheets, Forecast, Actuals, Combined. I have a formula in the Combined sheet which collects information from forecast cells, but when there are Actuals the formula takes the information from the Actuals sheet. To do this I have to change the heading in the Combined sheet from Forecast to Actuals. Formula is as follows: =+IF(D$4="Actuals",Actuals!D7,IF(D$4="Forecast",Forecast!E7,"ERROR")). The spreadsheet keeps asking me to "Update Value: Forecast" and I can't proceed. Can you help please? Barbara
Solved by V. E. in 24 mins