My old nemesis has returned - displaying the formula ( B2 array) rather than the result. Yes I have checked advanced options and yes I (kind of) tried to set format general, delete the =, enter, put it back. That kind of doesn't work with an array?

Item_Number Extract

840-00363-02 {=IF(LARGE((LEFT($A$2:$A$15,9)=LEFT($A2,9))*(SUBSTITUTE($A$2:$A$15,"-","")),1)=--SUBSTITUTE($A2,"-",""),SUM(B1,1),B1)}

840-00363-00 {=IF(LARGE((LEFT($A$2:$A$15,9)=LEFT($A2,9))*(SUBSTITUTE($A$2:$A$15,"-","")),1)=--SUBSTITUTE($A2,"-",""),SUM(B1,1),B1)}

840-00362-02 {=IF(LARGE((LEFT($A$2:$A$15,9)=LEFT($A2,9))*(SUBSTITUTE($A$2:$A$15,"-","")),1)=--SUBSTITUTE($A2,"-",""),SUM(B1,1),B1)}

840-00362-01 {=IF(LARGE((LEFT($A$2:$A$15,9)=LEFT($A2,9))*(SUBSTITUTE($A$2:$A$15,"-","")),1)=--SUBSTITUTE($A2,"-",""),SUM(B1,1),B1)}

840-00362-00 {=IF(LARGE((LEFT($A$2:$A$15,9)=LEFT($A2,9))*(SUBSTITUTE($A$2:$A$15,"-","")),1)=--SUBSTITUTE($A2,"-",""),SUM(B1,1),B1)}

840-00361-01 {=IF(LARGE((LEFT($A$2:$A$15,9)=LEFT($A2,9))*(SUBSTITUTE($A$2:$A$15,"-","")),1)=--SUBSTITUTE($A2,"-",""),SUM(B1,1),B1)}

840-00361-00 {=IF(LARGE((LEFT($A$2:$A$15,9)=LEFT($A2,9))*(SUBSTITUTE($A$2:$A$15,"-","")),1)=--SUBSTITUTE($A2,"-",""),SUM(B1,1),B1)}

840-00343-01 {=IF(LARGE((LEFT($A$2:$A$15,9)=LEFT($A2,9))*(SUBSTITUTE($A$2:$A$15,"-","")),1)=--SUBSTITUTE($A2,"-",""),SUM(B1,1),B1)}

840-00343-00 {=IF(LARGE((LEFT($A$2:$A$15,9)=LEFT($A2,9))*(SUBSTITUTE($A$2:$A$15,"-","")),1)=--SUBSTITUTE($A2,"-",""),SUM(B1,1),B1)}

840-00308-01 {=IF(LARGE((LEFT($A$2:$A$15,9)=LEFT($A2,9))*(SUBSTITUTE($A$2:$A$15,"-","")),1)=--SUBSTITUTE($A2,"-",""),SUM(B1,1),B1)}

840-00308-00 {=IF(LARGE((LEFT($A$2:$A$15,9)=LEFT($A2,9))*(SUBSTITUTE($A$2:$A$15,"-","")),1)=--SUBSTITUTE($A2,"-",""),SUM(B1,1),B1)}

840-00303-01 {=IF(LARGE((LEFT($A$2:$A$15,9)=LEFT($A2,9))*(SUBSTITUTE($A$2:$A$15,"-","")),1)=--SUBSTITUTE($A2,"-",""),SUM(B1,1),B1)}

840-00303-00 {=IF(LARGE((LEFT($A$2:$A$15,9)=LEFT($A2,9))*(SUBSTITUTE($A$2:$A$15,"-","")),1)=--SUBSTITUTE($A2,"-",""),SUM(B1,1),B1)}

840-00301-00 {=IF(LARGE((LEFT($A$2:$A$15,9)=LEFT($A2,9))*(SUBSTITUTE($A$2:$A$15,"-","")),1)=--SUBSTITUTE($A2,"-",""),SUM(B1,1),B1)}