Hi dataLove,

With your simple setup, use the VLOOKUP function in Sheet B... so if your first Part Number is in A2, then put this formula in B2...

=VLOOKUP(A2,'Sheet A'!$A$2:$B$1000,2,0)

where 'Sheet A'!$A$2:$B$1000 is the range that will depend on your actual data...

Hope this helps,
Dennis