I have a situation like this,
I have two tables, Table1 one has only customer codes in it, and I have Table2 with plenty of customer codes and those customer name, surname, age, location...
And I want to match and copy each of those customer codes in Table 1 all the information which is on Table2
Table 1:
50025
50026
50086
Table 2: Considering that name, age and location is each in separate cell
50025 John Second 25 Location 1
60085 Emily Third 20 Location 2
45454 Wilhelm Fourth 35 Location 3
10000 Rose Fifth 60 Location 4
50086 Johny Sixth 45 Location 5
65501 Jacob Seventh 18 Location 6
50026 Jackie Eighth 22 Location 7
And the outcame should be that it finds the value from Table1 in Table2 and copy's information in Table 1 like this:
50025 John Second 25 Location 1
50026 Jackie Eighth 22 Location 7
50086 Johny Sixth 45 Location 5
Bookmarks