Complex VLOOK and/or Index formula question. Expert advice needed

**p24leclerc** · 02-26-2013, 09:30 PM

you won't have to add new criteria. The formula criteria is based on the column title which is the month and year of the report.
I think it is better to have all data in the same tab.
You may also look at Pivot Table as this is a great tool to report data like you have in your DATA tab. You might have to add two field (month and Year) to ease reporting.

**GRDecker** · 02-27-2013, 10:44 AM

Hi - I added the month of March into the Tables and copied the formula over for each of the Hours, Cost, and Revenue tables. I copied from Feb to March. I then added charges for the month of March in the data tab. How come the data for March does not appear in the Tables now? Is there something else that needed to be added to the formula? Updated spreadsheet attached.

Excel Forum Sample 1v2.xlsx

Thanks

**GRDecker** · 03-01-2013, 06:17 PM

Excel Forum Sample 1v3.xlsx

I created a formula based on what I needed to do. Do you think you could take a look at how this works and see if there are any flaws? The one major problem I have right now is that the formula is updating the total hours for that one person as oppose to just the specific month.