actually i have to use the monthly average field to feed into another
worksheet, which is a consolidation sheet.
the consolidated worksheet lists the departments uniquely, and i have
to search the corresponding entry of department in this sheet, then
the average, then the monthly average field, all from this other
consolidation sheet. i hope i am able to explain the problem
properly...