List dollar difference for items

Hello All, I have a 2 lists of items. First I need to look at list B (Current Day Inventory) and if there is a match on list A (Prior Day Inventory) subtract the dollars difference. I have a formula to do the match: =IFERROR(INDEX($C$2:$C$20,SMALL(IF(COUNTIF($A$2:$A$20,$C$2:$C$20)=1,ROW($C$2:$C$20)-1,1E+99),ROW()-1),1),"") and the dollar difference: =IFERROR(VLOOKUP(E2,$C$2:$D$21,2,FALSE)-INDEX($A$2:$B$21,MATCH(E2,$A$2:$A$21,0),2),""). I also need to add the Items that are listed on list B (Current Day inventory) but not on list A (Prior Day Inventory) and the dollar amount.

Prior Day Inventory Current Day Inventory Match Items Dollar Difference
SM100-GEI210-AMP-EVDO-Z $1,206,566 SM100-GEI210-AMP-EVDO-Z $1,206,566 SM100-GEI210-AMP-EVDO-Z $0
574129-001 $1,100,353 574129-001 $1,145,995 574129-001 $45,642
SM100-GEI210-CDMA-C24 $867,048 SM100-GEI210-CDMA-C24 $841,568 SM100-GEI210-CDMA-C24 -$25,480
513607-003 $831,534 513607-003 $831,534 513607-003 $0
513877-001 $756,780 513877-001 $755,446 513877-001 -$1,334
5780544 $548,706 5780535 $593,145 5780544 $0
SM600-2S-CL200 $489,008 5780544 $548,706 SM600-2S-CL200 $15,973
514243-001 $478,589 SM600-2S-CL200 $504,981 6510536 $0
6510536 $463,744 6510536 $463,744 444183-003 -$4
444183-003 $452,927 513895-002 $460,957 SM100-EA3-GSM-3G $0
SM100-EA3-GSM-3G $433,019 444183-003 $452,923 513912-007 $0
513912-007 $432,707 SM100-EA3-GSM-3G $433,019 SM100-EA3-G24 $0
SM100-EA3-G24 $418,148 513912-007 $432,707 513544-003 -$1,075
513544-003 $405,024 SM100-EA3-G24 $418,148 514162-001 -$6,539
514162-001 $399,341 442027-001 $416,177 55T-SGRMU-001E $0
55T-SGRMU-001E $372,219 513544-003 $403,949 5780535 $593,145
K443834-018 $349,929 514162-001 $392,802 513895-002 $460,957
570974-001 $325,461 55T-SGRMU-001E $372,219 442027-001 $416,177
514064-001 $301,361 574054-001 $360,910 574054-001 $360,910

See attached file Mike

Mike,
I need to look at the items listed under current day inventory (col C) and do 2 things: 1) If the item matches an item in the prior day inventory column (col A)then subtract the dollar difference between the 2 (column d less column b. Also, if there is an item in column C that does not have a match in column A then list that item and the dollar amount.

Hope this cleared up my problem.

Mike, works great to get the dollar difference amount. Need to also change by matching items formula in column E:{ =IFERROR(INDEX($C$2:$C$20,SMALL(IF(COUNTIF($A$2:$A$20,$C$2:$C$20)=1,ROW($C$2:$C$20)-1,1E+99),ROW()-1),1),"") } as this is only picking up the items that match not the ones that have no match.

Think you're right and will need to go in that direction.

Thanks Mike