find the data of the corresponding column

[liu]

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,

 

[Lars-Åke Aspelin]

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,

Have a look at the VLOOKUP function.
Use FALSE as the value for the range_lookup parameter.

Hope this helps / Lars-Åke

 

[liu]

Have a look at the VLOOKUP function.
Use FALSE as the value for the range_lookup parameter.

Thank you so much for the pointer. That solves it.