Can you expand on that? I take it FOLDER is WORKSHEET?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Kent Horsley" wrote in message
...
I am currently working on a sales forecasting model with a IF statement
that
says
=IF(jan!$m7="january".jan!$n7,0) which works very well as long as I am
looking only at Jan folder. My question is can you do a if statement that
can
look from a jan folder through a Dec folder.
--
khorse