Need formula or vba code to find table values from code of rows value

[nethunter]

i have 3 set of data value with code value , i want list out table values from source code values

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

 

[Eric W]

Welcome to the MrExcel forum!

There are a lot of threads discussing this. Check out this link:

All possible permutation/combinations

Good morning! Forgive me, but I don't remember the difference between permutations and combinations, so hopefully my explanation points in the proper direction. I have two ordered lists (NORTH|SOUTH|EAST|WEST) and (N|S|E|W) and I want to make a listing of all permutations/combinations...

www.mrexcel.com

That has formula and VBA options.