I am having trouble trying bring data from sheet 1 layed out as follows:

A B C

PARTName01 Shipped 3
Not Receipted 1
Value Not Receipted $1,114.00
% Compliant 66.67%

There are mulitple and specific part namesgoing down sheet 1 in the same
manner. I amtrying to use a lookup table in sheet 2 that references the
specific partname and am trying to get the value of the "not receipted" in
column C.

Can anyone hwelp with this?