Table lookup and concatenate

Gang,

I have two tables of data. I would like to lookup a all data items in the second table (first col) in the first table (first col) and if found concatenate the associated text data to that of the text data in the first Table.

Data example;
Table 1 Table 2
9876 a 1234 z
8765 b 2345 y
7654 c 3456 x
3456 d 4567 w

The result of the function would be table 1, would show the item 3456 with the text field amended to d,x
3456 d,x
Can anybody help with this, cheers Sherriff

Oeldere,

Thats great, Thank you.

Could I ask is there a way to put the formula in sheet 2 but have the result answered or written into the text col in sheet 1?

Dilipandy,

Thank you for your offer of help as you can see Oeldere has provided a very good answer, but as requested here is a sample worksheet.

Book1.xls

Thank you Sherriff

oeldere,

Your very fast, I am sorry I am not making myself clear.

Sheet 1 will contain the primary data and sheet 2 will contain the new data.

I would like to check the new data(sheet 2) against the primary data(Sheet 1) and if a previously identified number exists in sheet 1 the text field in sheet 1 should be updated with the additional text field associated with the found record in sheet 2.

I hope this is clear

Sherriff

Sorry I was not sure how to mark it as solved hope this is correct

Sherriff