I am looking for some assistance on how to approach a problem.
Imagine a large list of say clubs, over 700 of them, in Column 1 and then in Columns B,C,D & E are listed up to 4 members.
Now in another worksheet is a list of all those members, and I want to extract which clubs those members belong to, the challenge is that the member does belong to multiple clubs and will appear potentially multiple times in columns B,C,D and E of the first worksheet. So a member could belong to say 8 or more clubs.
So how do I extract from my data a list of the clubs any one member belongs to?
Apologies if I am missing something, but I cannot yet solve this with VLookup, Index and Match or a pivot table.
Is it linked pivot tables?
Thank you for your help
Bookmarks