Thread: [Solved] Compare 4 columns & find dissimilar
View Single Post
 
Old 06-28-2011, 02:19 PM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default
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).
Reply With Quote