Forum Discussion
Vlookup for multiple tables
You are, indeed, making a very fundamental (and, sadly, fairly common) mistake. By storing the raw data in the fashion you are using, you are actually interfering with Excel's amazing abilities to do the very thing you're wanting to do: produce a summary report where Excel does all the work.
I've re-arranged some of your raw data into a single database in order to show you how the Pivot Table will automatically produce the kind of summary you are wanting, from a single table. The fundamental advice: LET EXCEL DO THE HEAVY LIFTING.
I only did the first two weeks of october in order to illustrate, but once all those days' data were reassembled into a singe table, Pivot Table was able to produce the summary report you see. It probably isn't exactly what you want; actually, with a more complete database (adding the days from September, August--the whole year-- for example) Excel will start giving you the ability to collapse into weekly or monthly or quarterly summaries by project, by person. There's a lot of flexibility in how to array the data. But you have to let Excel do the work of separating data by week, by person, etc.
You'll find videos on YouTube that can help understand the power of, as well as how easy it is to use, Pivot Tables. Here's an on-line resource as well. https://exceljet.net/excel-pivot-tables
You are, indeed, making a very fundamental (and, sadly, fairly common) mistake. By storing the raw data in the fashion you are using, you are actually interfering with Excel's amazing abilities to do the very thing you're wanting to do: produce a summary report where Excel does all the work.
I've re-arranged some of your raw data into a single database in order to show you how the Pivot Table will automatically produce the kind of summary you are wanting, from a single table. The fundamental advice: LET EXCEL DO THE HEAVY LIFTING.
I only did the first two weeks of october in order to illustrate, but once all those days' data were reassembled into a singe table, Pivot Table was able to produce the summary report you see. It probably isn't exactly what you want; actually, with a more complete database (adding the days from September, August--the whole year-- for example) Excel will start giving you the ability to collapse into weekly or monthly or quarterly summaries by project, by person. There's a lot of flexibility in how to array the data. But you have to let Excel do the work of separating data by week, by person, etc.
You'll find videos on YouTube that can help understand the power of, as well as how easy it is to use, Pivot Tables. Here's an on-line resource as well. https://exceljet.net/excel-pivot-tables