I feel i need to clarify things.

I'm trying to make it so that if someone selects "John Smith" from the dropdown in combobox1 (which is populated from all unique names in colA), they are presented with a list of items that appear next to that name. So....

colA colC
John Smith Item1
Sarah Jane Item2
Jim Beam Item3
John Smith Item4

If john smith is selected, then listbox1 would be populated by Item1 and Item4.