Tuesday, January 5, 2016

yogi_Pull Row By Row Matching Items By Month And Category From Import Sheet

Google Spreadsheet   Post  #2008
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-05-2016
post by: smithbc:
https://productforums.google.com/forum/#!topic/docs/P6tiI5QsNZE;context-place=forum/docs
Index Match Multiple Criteria (rows and columns) help
Here is a sheet with my desired results: 

I'm trying to write a formula that would go in the "Forecast" Sheet  that pulls from the "Import" sheet. 

The import sheet is copy and pasted from an accounting system report. 

The forecast sheet is a budget sheet where the budgeted numbers get updated each month with the actuals from that month, but the rest of the columns remain budgeted amounts. We are trying to find a formula that could update these automatically by matching the account name and the month of the data regardless of the format of the accounting system report.

I would like the formula to match on the account name (i.e. Sales, Travel, Office Supplies, etc.) and the month. The accounting system report puts the months in reverse order, and we would prefer not to have to rearrange these each time. 

Any help is greatly appreciated.
------------------------------------------------------------------------------

No comments:

Post a Comment