Use the example below, "," is the delimiter between cells.
item1, content1, code1, 111
item2, content2, code2, 23
item3, content3, code3, 11
item1, content1, code1, 34
item4, content4, code4, 222
item2, content2, code2, 45
item4, content4, code4, 33

I've simplified the items to
item1
item2
item3
item4

I'd like to have Excel to pick up the data of the next column of the
same row (eg. item1 = content1). It's kind of sumproduct that matches
the data, but it just place the first text it finds instead of adding
up all occurance.

Thanks for the help,