Please Help!! Duplicate values with multi. quantities, Vlookup? Something else?

[Mke49048]

Need help… Vlookup will only being the first instance back with duplicate valves. In my case I am looking a large amount of part numbers and bring the quantity back. Many of the part numbers repeat with different quantities, with vlookup it only brings the first instance of the part numbers quantity back. <o></o>
[TABLE="class: MsoTableGrid, align: left"]
<TBODY>[TR]
[TD="bgcolor: transparent"]A<o></o>
[/TD]
[TD="bgcolor: transparent"]10<o></o>
[/TD]
[/TR]
[TR]
[TD="width: 72, bgcolor: transparent"]B<o></o>
[/TD]
[TD="width: 72, bgcolor: transparent"]1<o></o>
[/TD]
[/TR]
[TR]
[TD="width: 72, bgcolor: transparent"]A<o></o>
[/TD]
[TD="width: 72, bgcolor: transparent"]5<o></o>
[/TD]
[/TR]
[TR]
[TD="width: 72, bgcolor: transparent"]C<o></o>
[/TD]
[TD="width: 72, bgcolor: transparent"]3<o></o>
[/TD]
[/TR]
[TR]
[TD="width: 72, bgcolor: transparent"]A<o></o>
[/TD]
[TD="width: 72, bgcolor: transparent"]21<o></o>
[/TD]
[/TR]
[TR]
[TD="width: 72, bgcolor: transparent"]E<o></o>
[/TD]
[TD="width: 72, bgcolor: transparent"]2<o></o>
[/TD]
[/TR]
</TBODY>[/TABLE]
<o></o>
I need it to bring all the values of A back with the different quantities, not just 10.<o></o>
<o></o>
Thank you. <o></o>
<o></o>
<o></o>

 

[Andrew Poulsom]

Formula in D1 copied down and across:

Excel 2010

	A	B	C	D	E
A	A
B	A
A	A
C
A
E

<TBODY>
[TD="align: center"]1
[/TD]

[TD="align: right"]10
[/TD]
[TD="align: right"][/TD]

[TD="align: right"]10
[/TD]

[TD="align: center"]2
[/TD]

[TD="align: right"]1
[/TD]
[TD="align: right"][/TD]

[TD="align: right"]5
[/TD]

[TD="align: center"]3
[/TD]

[TD="align: right"]5
[/TD]
[TD="align: right"][/TD]

[TD="align: right"]21
[/TD]

[TD="align: center"]4
[/TD]

[TD="align: right"]3
[/TD]
[TD="align: right"][/TD]

[TD="align: center"]5
[/TD]

[TD="align: right"]21
[/TD]
[TD="align: right"][/TD]

[TD="align: center"]6
[/TD]

[TD="align: right"]2
[/TD]
[TD="align: right"][/TD]

</TBODY>

Sheet1​

[TABLE="width: 85%"]
<TBODY>[TR]
[TD]Array Formulas[TABLE="width: 100%"]
<TBODY>[TR="bgcolor: #dae7f5"]
[TH="width: 10"]Cell
[/TH]
[TH="align: left"]Formula
[/TH]
[/TR]
[TR]
[TH="width: 10, bgcolor: #dae7f5"]D1
[/TH]
[TD="align: left"]{=IFERROR(INDEX(A$1:A$6,SMALL(IF($A$1:$A$6="A",ROW(A$1:A$6)-ROW(A$1)+1),ROWS(D$1:D1))),"")}
[/TD]
[/TR]
</TBODY>[/TABLE]
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself
[/TD]
[/TR]
</TBODY>[/TABLE]