Need formula to find correct worksheet and column from text label

Originally Posted by Ochimus

Richard,

Appreciate the prompt suggestion, but unfortunately you are using separate selections for the category (Actual, Budget and Forecast) and the Month, which is not what the End User asked for, so it's not viable.

Ochimus

By joining two different things in a single drop down, i.e. a date and a worksheet you unnecessarily complicate things. It seemed to me that it wasn't too onerous a request to ask the user to select both a worksheet and a month instead of the two being combined. However the attached simply uses the original idea and converts the actual selection to the two constituent parts of date and sheet so that the original formulae I gave you will still work.