I have 2 databases, both based on part numbers. I need to compare the two and find if the two databases have the same part & the same letters & the same values. They are also very mixed and some parts are different in both databases, therefore they cannot all match, but I need to match up what I can, so I can then compare the databases to see if they are the same.
I am not too sure if this makes any sense, but here is an example listing:
Database 1 Database 2
Part Let Val Part Let Val
72822 aa 22 72824 cc 44
72823 bb 60 72825 dd 45
72824 cc 44 72826 ee 100
72830 ii 98 72827 ff 64
72826 ee 100 72828 gg 59
72827 ff 64 72829 hh 72
72828 gg 59 72830 ii 98
- therefore I need a formula to search for the same enteries in both databases and return the values for example, or a variance
- for example 72830 ii 98 are the same in both databases.
I hope I have explained this clearly.
Thanks.
I am not too sure if this makes any sense, but here is an example listing:
Database 1 Database 2
Part Let Val Part Let Val
72822 aa 22 72824 cc 44
72823 bb 60 72825 dd 45
72824 cc 44 72826 ee 100
72830 ii 98 72827 ff 64
72826 ee 100 72828 gg 59
72827 ff 64 72829 hh 72
72828 gg 59 72830 ii 98
- therefore I need a formula to search for the same enteries in both databases and return the values for example, or a variance
- for example 72830 ii 98 are the same in both databases.
I hope I have explained this clearly.
Thanks.