Unique List Creation

[brncfan7]

I built a spreadsheet to inventory parts. In the first tab, labeled "All Parts List", I plan to keep a running list of of parts as they come into a warehouse. There will be duplicate parts as orders come in so I want to create a unique list based off of that first tab. So, I created a second tab labeled "Unique Parts List" and used a lookup function along with an INDEX/MATCH formula to extract unique values and sum up total parts.

My data set is as follows in the All Parts List Tab:

Column B: Part Number
Column C: Part Type
Column D: Quantity
Column E: Part Description

So in the Unique Parts List tab, I created the following formulas:

To extract the list of unique parts numbers:=IFERROR(INDEX('All Parts List'!$B$3:$B$1500,MATCH(0,INDEX(COUNTIF('Unique Parts List'!$B$3:B3,'All Parts List'!$B$3:$B$1500),0,0),0)),"")
To match the description of the part number extracted: =IFERROR(LOOKUP(B4,'All Parts List'!$B$3:$B$1500,'All Parts List'!$E$3:$E$1500),"")
To match the part type: =IFERROR(LOOKUP(B4,'All Parts List'!$B$3:$B$1500,'All Parts List'!$C$3:$C$1500),"")
To match the quantity: =SUMIFS('All Parts List'!$D$3:$D$1500,'All Parts List'!$B$3:$B$1500,'Unique Parts List'!B4)

If I add a new parts to the All Parts tab, the descriptions in the Unique Parts tab no longer line up with the correct part number or quantity, and I have not been able to figure out why. Any help would be appreciated. Thanks!

[PeteABC123]

Please post a short sanitized sample of the spreadsheet.

[brncfan7]

I have attached my working spreadsheet

[PeteABC123]

Try this and report back.
On your Unique Parts List in C4 (copy down) =IFERROR(VLOOKUP(B4,'All Parts List'!$B$3:$E$1500,4,FALSE),"")
On your Unique Parts List in D4 (copy down) =IFERROR(VLOOKUP(B4,'All Parts List'!$B$3:$E$1500,2,FALSE),"")

Pete

[brncfan7]

That seemed to clear up the issue. Thank you!

[PeteABC123]

Glad it worked out.
Pete