Combining two distinct tabs

[DominicJ]

Hi All
I have two tabs

The first tab, has a list of Usernames, and the approval groups they sit in
Some users sit in one approval groups, some users sit in many.
Some approval groups have one approver, some have many

The second tab, has a list of cost centres, and the approval group they sit in
All cost centres have one approval group, but many cost centres sit in each approval group


I start with a cost centre, and need to return all of the relative approver names
A simple lookup on the cost centre tab, using the approval group, returns only one name, when there might be 10

My current workaround is the following
I have pivoted both tabs to a third tab,
I filter the cost centre pivot for my required cost centre, to return the approver group
I then filter the approver group pivot using the approver group I have found on the first pivot, this returns me the names I need

But as a process, its a pain.


The system is unable to generate a combined list, detailing all of the duplicates.
There are 1200 cost centres, so creating this manually is out of the question.

[Glenn Kennedy]

Can you attach a sample worksheet? Currently we don't know what is where....

Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

Click on GO ADVANCED and use the paperclip icon to open the upload window.

The paperclip icon

[DominicJ]

My work system is being a special little snowflake and refusing to upload
I'll email it home and upload from there later

[Glenn Kennedy]

No. It's maybe not your work system. It's almost certainly the forum, which can be a bit flakey when it comes to attachments...