Attached update 151101 Comparisons v3.xlsx has what must be the longest formula I've ever experienced.

Combining Jason's "Quarter and Annual" formula with Pete's original that (almost) worked for the dates, the User can now select the sentence specifying either a Month, Quarter or Year as Actual, Budget or Forecast, and the formula pulls up the relevant data.

EXCEPT that it still pulls the 2017 Total from Col BB of each sheet if you select any month between April - Dec 17.

I've even retyped them from scratch, to no avail.

If someone can just see why it's not "doing what it says on the tin" in those nine months, I can close this out, and you can all enjoy well-deserved plaudits.

Ochimus