Vlookup Excel 2007 - Not Capturing All the Duplicates

Good afternoon Excel Experts! I have used this template for a Vlookup and have been having troubles that I simply cannot pin down. Some duplicated numbers in Columns A and C will NOT appear in Column B. I am also trying to work it out where when the results are displayed that Excel will tell me in a pivot how many loans are on both lists and how many loans are on each specific list. Any little bit of assistance would be GREATLY appreciated.