I have attached screen shot as raw data, tried using vlookup and index match but no correct result is display in mention below table (output).
Idea is if user select a month then records should be displayed in respective cell.
output as table below, any suggestion as what would be a best formula is get data from (raw data screen shot) it. If require i can share excel file as well
Idea is if user select a month then records should be displayed in respective cell.
output as table below, any suggestion as what would be a best formula is get data from (raw data screen shot) it. If require i can share excel file as well
| ITEMS | Apr-22 | |||
| Gross Income (Sales) | ₹ 43,29,300 | ₹ 0 | ||
| Direct Overheads | Projected | Actual | ||
| Employee Salary, Benefits & Mgmt. Cost (Direct) | ₹ 10,89,700 | ₹ 0 | ||
| Hosting (Direct) | ₹ 0 | ₹ 0 | ||
| Calling Cost (Direct) | ₹ 0 | ₹ 0 | ||
| Sales & Marketing Expenses (Direct) | ₹ 0 | ₹ 0 | ||
| HR (Direct) | ₹ 0 | ₹ 0 | ||
| Administrative, Operational (Indirect) | ₹ 0 | ₹ 0 | ||
| Facility / Infrastructure Cost (Indirect) | ₹ 0 | ₹ 0 | ||
| Cost of Sales | 10,89,700 | 0 | ||
| Gross Margin | 32,39,600 | 0 |
