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