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?