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