Lookup value and then combine values in row

[grappler]

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