Compare 4 columns & find dissimilar

I have 2 spreadsheets with 2 columns in each that I need to compare. Sheet A has a part and a price column, as does Sheet B. I need to compare the part column in A to B and then the price column in A to B and if the price of the part in A is different than the price of the part in B, I need to calculate the difference in a separate column. Can anyone help?

Something like this...

If the part is not available then it will give you #N/A. If you would like to add condition for not found parts then use:

Quote:

---

=IF(ISERROR(VLOOKUP(A2,Sheet2!A:B,2,FALSE)),"NOT FOUND",(B2-VLOOKUP(A2,Sheet2!A:B,2,FALSE)))

---