Dear Experts

I need an formula or vba code to find product values from its code

for e.g

3 tables have set of data
Table A TAble B TAble C Code Expected result
1 LONDON 1.BTS 1.CAMERA 111 london,bts,Camera
2 German 2.fuji 2.Lens 112 london,bts,Lens

find the attachment

Attached Images

lili.JPG (124.5 KB, 14 views)