PDA

View Full Version : Compare 4 columns & find dissimilar



fjhsui
07-01-2011, 08:35 PM
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?

georgiboy
07-01-2011, 09:58 PM
Something like this...

shrivallabha
07-02-2011, 12:09 AM
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:

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