find the data of the corresponding column
 

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,

find the data of the corresponding column
 

On Thu, 1 May 2008 12:34:58 -0700 (PDT), liu
wrote:

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

find the data of the corresponding column
 

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.