B
Bruce Joiner
I need to match (or find like kind) in different columns. I also need associated data (in other columns) to follow the columns when they are matched. In the example Column A has associated data in column B. Column C has associated data in column D. How do I match data in columns A and C and ensure data integrity in columns B and D.
Example
Column
A B C D A B C
1 a 3 x 1 a 1
3 x 7 z 3 x 3
7 z 0 l 7 z 7
9 k 1 a 9 k 9
0 l 9 k Match Columns 0 l 0 l Matched data should look like this
Application
If I have a list of parts that have been sent off for repair and the repair man sends me a scrambled list of items/parts that have been completed. How can I match the completed part numbers to the master list without searching for each number manualy?
Example
Column
A B C D A B C
1 a 3 x 1 a 1
3 x 7 z 3 x 3
7 z 0 l 7 z 7
9 k 1 a 9 k 9
0 l 9 k Match Columns 0 l 0 l Matched data should look like this
Application
If I have a list of parts that have been sent off for repair and the repair man sends me a scrambled list of items/parts that have been completed. How can I match the completed part numbers to the master list without searching for each number manualy?