mart_mrexcel
Active Member
- Joined
- Aug 23, 2008
- Messages
- 295
- Office Version
- 365
- Platform
- Windows
How can i get the Actual amount (in Sheet1 Template) with 2 criteria as Horizontal and 1 criteria as vertical in Sheet2 (i.e. my Master Data). See below sample
Template in Sheet1
<TBODY>
</TBODY>
Data in Sheet2
<TBODY>
</TBODY>
Template in Sheet1
Month | CC | GL Codes | Actual Amount |
April-13 | FIN | 4200010 | 55 |
April-13 | HR | 4200020 | 648 |
Feb-13 | MFG | 4200030 | 489 |
April-13 | MFG | 4200040 | 1563 |
April-13 | SALES | 4200020 | 260 |
<TBODY>
</TBODY>
Data in Sheet2
Month | CC | 4200010 | 4200020 | 4200030 | 4200040 |
April-13 | SALES | 2657 | 260 | 564 | 1500 |
April-13 | HR | 10 | 648 | 223 | 655 |
April-13 | FIN | 55 | 9876 | 10000 | 689 |
April-13 | MFG | 66 | 6543 | 5000 | 1563 |
Feb-13 | HR | 69 | 65 | 664 | 15687 |
Feb-13 | FIN | 29 | 64 | 698 | 2648 |
Feb-13 | MFG | 69 | 49 | 489 | 2546 |
<TBODY>
</TBODY>