find the data of the corresponding column

  • Thread starter Thread starter liu
  • Start date Start date
L

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,
 
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,
Click to expand...

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

Hope this helps / Lars-Åke
 
Back
Top