I am trying to create formulas to reconcile checks quickly for a bank account. I have the outstanding checks from previous months in columns A thru D with check # in column A and amount in Column D. (Column E is a placeholder). I have the checks that cleared from the bank in columns F thru G. (Column I is a placeholder) and the cleared check number is in column F and the cleared check amount is in column H. In Column J is the formula =IF(VLOOKUP(A4,$F$3:$H$500,1,FALSE),"Cleared","") to check to see if the checks in columns A thru D cleared the bank. I have a formula in column L =VLOOKUP(A3,$A$3:$D$5000,4)-VLOOKUP(A3,$F$3:$H$5000,3) that is trying to compare the amounts for the checks that have cleared to see if there is a difference. I do not think the formulas are giving me what i need.

https://www.dropbox.com/s/cqhjtly07i...File.xlsx?dl=0