Hi bakermetal,

welcome to the forum and thanks for revising your thread title.

if I understand your requirements correctly, you could try this formula in the "Applied Parts" sheet in cell D2 and copy down

=VLOOKUP(C2,Data!$A$2:$B$315,2,FALSE)

hth