Help with a process / formula(s) to look up variable values and return the data

durendal 

Totally understand and thank you for your assistance so far. I've managed to remove some of the sensitive information from the attached Workbook, which is the one i wanted to use.

I would really appreciate if you could help by applying the same principals to this workbook.

Essentially, the months run from April to May and the analysis tab is call "Requester Summary".

Within the requester summary are tables which is where i need the data retrieved to. The data for each table is listed below,

• BHM Table - Should show information for requesters associated with the team "BHM". Should show the requester name, total requests and value of requests for authorised requests only.
• Contract Hub / Directorate table - Should show information for requesters associated with the team(s) "Contract Hub" or  "Directorate". Should show the requester name, total requests and value of requests for authorised requests only.
• Neighbourhood Management & Community Protection table - Should show information for requesters associated with the team(s) "NHM" or "Community Protection". Should show the requester name, total requests and value of requests for authorised requests only.
• Parks, Leisure & Cemeteries Table - Should show information for requesters associated with the team "Parks", "Leisure" or "Cemeteries". Should show the requester name, total requests and value of requests for authorised requests only.
• Other Table - Should show information for requesters associated with the team "Other". Should show the requester name, total requests and value of requests for authorised requests only.

I hope the above makes sense ? Its in essence very similar to what you provided previously. Thanking you in advance for your time, help and patience on this !

Thanks

Raj