Vlookup on dept code then subtotal hrs according to filters?

[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?

[Jarvin24]

Hi Monik,

Welcome to the forum, please upload your template for our easy reference.

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)•Click Advanced (next to quick post),
•Scroll down until you see "Manage Attachments",
•Click that then select "add files" (top right corner).
•Click "Select Files" find your file, click "open" click "upload"
•Once the upload is completed the file name will appear below the input boxes in this window.
•Click "Done" at bottom right to close the Attachment Manager.
•Click "Submit Reply"

Tnx

[monikersupreme]

Some of the data is proprietary so it's difficult to provide examples. I may be able to create some "sample" data though. Let me see.

Hi Monik,

Welcome to the forum, please upload your template for our easy reference.

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)•Click Advanced (next to quick post),
•Scroll down until you see "Manage Attachments",
•Click that then select "add files" (top right corner).
•Click "Select Files" find your file, click "open" click "upload"
•Once the upload is completed the file name will appear below the input boxes in this window.
•Click "Done" at bottom right to close the Attachment Manager.
•Click "Submit Reply"

Tnx

[Jarvin24]

Right.. just a template that could provide the logic what you want...