There is bound to be another way, using some sort of lookup probably.

Can you give some details of the data, and what you need to do specifically,
and expected results?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"don" wrote in message
...
I would like to use a nested if function to display a months work
summary in a single area using a scroll bar. I have used this to good
effect for small amounts of data tables but would like to extend it to
displaying information covering 12 separate months. I know you can only
nest an if function up to 8 times I believe. Is there a way around this
that would let me display my 12 months of data I need to.

Regards

Don