EDIT - I can't use VBA at work so I'd appreciate a non-VBA option please 
I have two workbooks that I need to play with.
Both have an Opportunity ID field. I'm using the first one for most of my work, but the second one has a Products field that I need. Each Opp ID is associated with one or more Products.
How do I bring in the various Products associated with an Opp ID?
Here's the second spreadsheet:
[TABLE="width: 500"]
<tbody>[TR]
[TD]A1[/TD]
[TD]Computer[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]Phone[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]Keyboard[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]Cup[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD]Headphones[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD]Laptop[/TD]
[/TR]
</tbody>[/TABLE]
So in the first spreadsheet, when I start with one row for A2, and I don't know how many associated rows there are in the second one, how would I approach this?

I have two workbooks that I need to play with.
Both have an Opportunity ID field. I'm using the first one for most of my work, but the second one has a Products field that I need. Each Opp ID is associated with one or more Products.
How do I bring in the various Products associated with an Opp ID?
Here's the second spreadsheet:
[TABLE="width: 500"]
<tbody>[TR]
[TD]A1[/TD]
[TD]Computer[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]Phone[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]Keyboard[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]Cup[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD]Headphones[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD]Laptop[/TD]
[/TR]
</tbody>[/TABLE]
So in the first spreadsheet, when I start with one row for A2, and I don't know how many associated rows there are in the second one, how would I approach this?
Last edited: