Excel Spreadsheet Comparison and Analysis

have 2 tables each have job #s, the job #s are listed several times in each table for each type of revenue. So job 123 # may be listed 3 times because it had revenue from lights, picture, developer. I need to compare the two to ensure table 1 lights =table 2 lights, another wrench to throw in -is that table 1and 2 might also have unique job #s and I need those identified as well. Any ideas?