Lookup value and then combine values in row

grappler

New Member
Joined
Mar 15, 2013
Messages
3
Hello,

I have this table with data. If the numbers match then consolidate the data in the row into one cell dividing the values with a comma.

Number
Data 1
Data 2
Data 3

Number
Result
1
a
b
c
5
b
2


c
8
a
3
a
b

2
c
4
a

c
7

5

b

4
a, c
6

b
c
1
a, b, c
7



6
b, c
8
a


3
a, b

<tbody>
</tbody>

I am open to use a function or UDF.

I thought of combining two functions =VLOOKUP() and =CONCATENATE()

Here are some near solutions that I found but they consolidate the column data and not the row data.
http://www.get-digital-help.<wbr>com/2010/12/20/excel-udf-<wbr>lookup-and-return-multiple-<wbr>values-concatenated-into-one-<wbr>cell/
http://www.ozgrid.com/forum/<wbr>showthread.php?t=94895&p=<wbr>445111#post445111
http://www.ozgrid.com/forum/<wbr>showthread.php?t=25239&p=<wbr>128076#post128076
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Watch MrExcel Video

Forum statistics

Threads
1,109,542
Messages
5,529,453
Members
409,878
Latest member
DDhol
Top