Designing a flexible reporting template
 

From your formula, it looks like you've got some data in column A that
you are using to determine which columns data you would like some cell
to show. If I were you, I would put the names of the months in the
cells above the data for that month and use an HLOOKUP formula, like
this:

=HLOOKUP(A2, C$1:N$25, ROW(A2), FALSE)

The ROW(A2) part assumes you would like the data from the same row as
the cell that has the month in it.

Mark

"CiaraG" wrote in message ...
I am designing a reports template based on imported data.
The imported data comprises of 12 months figures for a
number of variables.

Normally I would design a template based on a fixed
structure so if a new variable was added to the list it
would need to be added manually. My formulae within the
template would take the form of a nested if statement, so
depending on the month selected, the relevant cell vale
would be displayed - see below.

=IF(A4="January",NominalCSS!D153,IF
(A4="February",NominalCSS!E153,IF(A4="March",Nomin alCSS!
F153,IF(A4="April",NominalCSS!G153,IF(A4="May",Nom inalCSS!
H153,IF(A4="June",NominalCSS!I153,IF(A4="July",Nom inalCSS!
J153,IF(A4="August",NominalCSS!K153))))))))+IF
(A4="September",NominalCSS!L153,IF(A4="October",No minalCSS!
M153,IF(A4="November",NominalCSS!N153,IF
(A4="December",NominalCSS!O153,0))))

This large formulae would normally leave my file very
large. Has anyone any ideas how I may best design a
flexible reporting model or has any examples that I amy
review.

Thanks in advance.

Regards,

Ciara