Compare 4 columns & find dissimilar

		Microsoft Office Forums > Microsoft Excel > Excel
Compare 4 columns & find dissimilar

06-28-2011, 02:19 PM

Colin Legg Colin Legg is offline

Windows 7 32bit Compare 4 columns & find dissimilar

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

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).

Tags

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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:07 PM.