Compare 4 columns & find dissimilar

kmorrin · #1 06-28-2011, 01:14 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?

OTPM · #2 06-28-2011, 02:07 PM

Hi
Please find attached your solution.
Hope this helps.
Tony(OTPM)

Colin Legg · #3 06-28-2011, 02:19 PM

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)),"")

This assumes that there are no duplicate parts in either sheet (which is implied by your question).

kmorrin · #4 06-29-2011, 01:41 PM

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.

Colin Legg · #5 06-29-2011, 04:38 PM

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.

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