Looking up all the child values associated with one parent value

**cwwazy** · 08-03-2015, 03:45 PM

Hello All,

I have workbook that has a list of parent values and child values. I am trying to associate all the child values to the one parent value.
For example, in column A, I have a list of names (Parent value). In column B, I have Sports Played (child values).
If I wanted to capture all the sports that John plays, is there a formula for me to do that? I have attached an example worksheet.

Just by glancing at the table, I know John plays Baseball, Football, and Tennis.
I have tried using a simple Vlookup, but I'm unable to capture all the values.

Excel Forum Example.xlsx

Thanks,

**MarvinP** · 08-03-2015, 03:48 PM

Hi cwwazy,

See if a quick Pivot Table helps with your answer.

**cwwazy** · 08-03-2015, 03:52 PM

Hi Marvin,

Thanks for the quick response. Any other way to do it without having to do a pivot table? I am trying to capture the cells without having to manually pivot and looking at the results?

**Loganeb** · 08-03-2015, 03:54 PM

Here you go.
Excel Forum Example.xlsx

**Ron Coderre** · 08-03-2015, 03:58 PM

Using your posted workbook....here are two approaches:

Pivot Table
• select the data range (A1:B10
• Insert.Pivot Table.Table
...Select a destination...Click: OK
...Drag Name to the Report Filter
...Drage Sports Played to the Row Labels

Select a name and the Pivot table will list the sports for that name

Formulas:
E1: Name
F1: a name to use...Adam
G1: Sports Played

This formula, copied down, lists the sports for that name

Please Login or Register  to view this content.

Is that something you can work with?

**MarvinP** · 08-03-2015, 04:04 PM

Hi,

What do you want the answer to look like? If you include that on your sample attached file, it might be possible to accomplish what you wish.

**cwwazy** · 08-03-2015, 04:08 PM

Thank you for the responses. That helped!

**Ron Coderre** · 08-03-2015, 04:09 PM

Glad you got something you can use!

If that resolves your issue, please take a moment to mark this thread as SOLVED (from the Thread Tools menu)

Looking up all the child values associated with one parent value

LinkBack

Thread Tools

Rate This Thread

Display

Looking up all the child values associated with one parent value

Re: Looking up all the child values associated with one parent value

Re: Looking up all the child values associated with one parent value

Re: Looking up all the child values associated with one parent value

Re: Looking up all the child values associated with one parent value

Re: Looking up all the child values associated with one parent value

Re: Looking up all the child values associated with one parent value

Re: Looking up all the child values associated with one parent value

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Sorting with Parent and Child

[SOLVED] Parent child relationships(working out parent item) for each item

Parent Child Relationship

Parent Child Macro

Sorting Parent Child

Bookmarks

Bookmarks

Posting Permissions