Spreadsheet showing that pieces of one part are received complete. For instance part A has multiple pieces need to know when all 7 are completed.

Column A Column B unique line number
Part Name Date Received 123
A 6/12/2016 456
A 6/10/2016 789
A NO 587
A 5/25/2016 875


on different tab in workbook I have done a vlookup to find part name, date received, unique line number.....but here is the problem I can not duplicate part name on this tab. I need maybe an IF statement that it just says complete, N/A, partial, and not done.

Any help would greatly be appreciated because I am STUMPED !!!

Thanks