index match array formula - replace cell references with ranges

I have been using this small example file to try to find a solution to a duplicates problem in a larger workbook.

when I use this formula

{=IF(LEN(D3),INDEX($B$7:$B$999,SMALL(IF($A$7:$A$999=D3,ROW($1:$993)),COUNTIF(D$3:D3,D3))),"")}

the desired result is found

but when I try to substitute the defined ranges with a named range

{=IF(LEN(D3),INDEX(NAME,SMALL(IF(CHARGE2=D3,ROW($1:$993)),COUNTIF(D$3:D3,D3))),"")}

I get random information

the actual formula I am trying to adapt to name each duplicate value name is

=INDEX(NAME,MATCH(LARGE(CHARGE2,1),CHARGE2,0),1)

any help appreciated. sample attached