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>
[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>