Compound Nested Lookup

[jennwess]

I am trying to do the following:

(1) Lookup Unique Resource ID
(2) then Lookup Unique Project ID
(3) then Lookup the Month for this resource
(4) Then Lookup the hours associated with the resource, multiple
Project IDs, and month
(5) Sum the resource hours for that group of projects and the
month

This data comes from a pivot table. Note: the resource and Project IDS are not part of the pivot table. I added them to assist in the lookups.

Can anyone please help.

 

[Smitty]

Welcome to the Board!

You're looking for SUMPRODUCT.

Here's a relevant example from a recent post.

It'll help if you can post an example or at least the individual ranges you're dealing with.

Hope that helps,

Smitty

 

[jennwess]

Conditional Nested lookup

The data (pivot table) comes from a website that users enter hours worked against projects into timesheets. This pivot table is exported to Excel. From there I link worksheets to the data. column A lists the resource's name, and the project they worked on. Columns B - G lists Jan - June. Then under each month is the total hours worked against the projects. I want this worksheet to pull the data from the pivot table, but it's under the condition that it has to lookup the resource's name, the projects they worked on and then sum it up. There are instances where there are duplicate projects listed for one business unit (IE Market Risk-001, Market Risk-002, etc...). These fields would need to be summed.

I would like to include an example but it won't let me. If I paste it the formatting is off.

 

[Smitty]

Re: Conditional Nested lookup

I would like to include an example but it won't let me. If I paste it the formatting is off.

Check out the link beneath my sig.

Smitty