Conditional formula

See attachment. What I am trying to accomplish is...
Multiple Item numbers (some are the same) but each have a diffrent Pass/Fail associated with it. I want to have an output on Column "D" to show what I have hand written in. The excel document looks like this but much bigger.

Forum Question.xlsx