Formula for matching the same fields

[aj3221]

I don't know if this can be done. I have a spreadsheet with tabs along the bottom for each month. Then I have an end of the year tab at the very end. The data in each month has customer #, customer name, 2008 sales, 2009 sales, comments. Each month new customers might be added in/taken off. In the end of the year tab I have the following columns: customer #, customer name, 2008 sales, 2009 sales, comments jan, comments feb, comments mar, comments apr (and so on). In the end of the year tab under comments feb I want it to match the customer # from the jan tab and pull the comments into the end of the year tab in the comments jan column. If it doesn't see a match or if the comments are blank the the jan comments are blank. I would repeat this formula to the other "comments jan-dec" tabs.

Is this possible or am I crazy?

 

[SkipVought]

Hi,

It is possible, but you're crazy for thinking that it can be done easily, using your workbook design.

You have chopped up your data into REPORT chunks (months). Typical mistake that novice spreadsheet users make.

Your DATA ought to be in ONE TABLE, that includes a column for DATE, not just month.

From a structure like that, your monthly and yearly aggregations could be produced in SECONDS, using Excel build-in features. As it is now, your worbook structure defeats and severely complicates Excel's capabilities.

So do the sane thing and restructure your data as a starting point.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}