Excel vlookup and subtotal?

[monikersupreme]

I have a huge table of data (almost 10k rows) and a deadline breathing down my neck. I think what I need to do can be accomplished by a combination of vlookup and subtotaling but I want to make sure I've got the right idea since I haven't much time for rabbit holes.



The data consists of hours worked and needs to be filtered by quarter, job type, part/full time, etc.. then subtotaled by department code.

I have a list of department codes for which I need to subtotal employee hours.

I need to be able to configure the filters to find different totals (or just have them all display accordingly).

Is there a way to do a vlookup by dept code then subtotal for all hours and have this update based on a set of filters?

[Pecoflyer]

At first glance a Pivot Table might be what you need

[monikersupreme]

Originally Posted by Pecoflyer

At first glance a Pivot Table might be what you need

I can set up the data as a pivot table for sure but I was hoping to find a way, given my separate table of dept codes, to create a new column just containing the subtotals I need (total hours per dept) and have this list of subtotals adjust based on how I've filtered the base dept data.

Is it possible to meet a subtotal function inside vlookup?

[Pecoflyer]

Perhaps post a sample sheet showing what you have and expected results