#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Hi
Please find attached your solution. Hope this helps. Tony(OTPM) |
#3
|
||||
|
||||
Welcome to the forum.
I think I'd use something along these lines: Code:
=IFERROR(B1-INDEX(SheetB!B:B,MATCH(A1,SheetB!A:A,0)),"") |
#4
|
|||
|
|||
Thanks! Is it possible to have the parts in sheet A check all of the parts in sheet B looking for a match? There are about 800 more parts in B than A. If not, I'll go thru them and make them match line to line.
|
#5
|
||||
|
||||
The formula I posted does check all of the parts in Sheet B, but if there are multiple matches then it only finds the first one.
|
Tags |
excel compare |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Compare and Update Macro | AaronMoss | Excel Programming | 2 | 05-06-2011 04:54 AM |
How to compare 2 columns with other two columns in EXECL 2007? | Learner7 | Excel | 5 | 06-12-2010 09:54 AM |
Compare document | enthu | Word | 1 | 05-19-2010 10:32 PM |
Compare data in different columns in an Excel sheet | kgfendi | Excel | 5 | 05-16-2009 05:42 PM |
compare files | rmartin8 | Word | 1 | 02-10-2009 10:27 AM |