Match Columns and Data

[cdubs34]

So I have two sets of data on separate sheets that I want to match and line up. I subsequently want a column of data that is associated with the data on one sheet to line up as well. For example

Sheet 1 Column E Sheet 2 Column C Sheet 2 Column D
Code Code Sales
2345 004458 45345
3455 003054 34534
4458 003455 94839
3054 004829 34291
002345 19348

I have a workbook with many data points like this so was wondering a quick, easy way to get the Sales Data on Sheet 2 to line up with the matching code from sheet 1. Also, note that the codes on Sheet 2 contain the codes from Sheet 1, but are not exactly the same (ie they have 00 and then the same code). Not sure if this is clear or makes sense. Any help you can provide is appreciated. Thanks

 

[Robert Mika]

This is not very clear.
Can you give an example in two separe tables with desired results?