Compare 1 column where column B matches

[csimpson24]

Hi all,

So I have a very large spreadsheet which contains all of our parts and part descriptions. It was merge between old data and new data. I am needing to see which part's descriptions have change from then and now.

When B is a match (part number), compare D (Description) and write match or mismatch in E for both matching part number rows.

Any help would be appreciated.

Thank you,
Chris

 

[sheetspread]

So I would put this formula in C2 and then drag it down to the last row of data?

Yes, and be sure the references line up:

Excel 2010
	A	B	C
1	Number	Description	Match?
2	30021.02	ROUND HOT ROLLED 1/4"	TRUE
3	30021.02	ROUND HOT ROLLED 1/4"	TRUE
Sheet4

Cell Formulas
Range	Formula
C2	=B2=IFERROR(VLOOKUP(A2,$A$1:$B1,2,0),"")&IFERROR(VLOOKUP(A2,$A3:$B11,2,0),"")

Change B11 to whatever your last row is also (even though there's no difference here)

 

[csimpson24]

I'm still getting FALSE
I have this in C2
=B2=IFERROR(VLOOKUP(A2,$A$1:$B1,2,0),"")&IFERROR(VLOOKUP(A2,$A3:$B111230,2,0),"")

And after dragging down into C3, I have this in C3
=B3=IFERROR(VLOOKUP(A3,$A$1:$B2,2,0),"")&IFERROR(VLOOKUP(A3,$A4:$B111231,2,0),"")

 

[csimpson24]

I did manage to clean the data up a bit, if this helps. Now, the part number in A2 = A3, A4 = A5, A6 = A7 and so on. All the way down to A111231.

 

[sheetspread]

Are there more than 2 of the same part numbers? What about descriptions?

 

[csimpson24]

Only 2 of each part number. 1 from each data source with descriptions for each. Notice I have a source column from where the data came from.

[TABLE="width: 405"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Part[/TD]
[TD]Description[/TD]
[TD]Match?[/TD]
[TD]Source[/TD]
[/TR]
[TR]
[TD]30021.02[/TD]
[TD]ROUND HOT ROLLED 1/4"[/TD]
[TD="align: center"]FALSE[/TD]
[TD]Epicor[/TD]
[/TR]
[TR]
[TD]30021.02 [/TD]
[TD]ROUND HOT ROLLED 1/4" [/TD]
[TD] [/TD]
[TD]Dawn[/TD]
[/TR]
[TR]
[TD]30021.06[/TD]
[TD]ROUND HOT ROLLED 1/2"[/TD]
[TD] [/TD]
[TD]Epicor[/TD]
[/TR]
[TR]
[TD]30021.06 [/TD]
[TD]ROUND HOT ROLLED 1/2" [/TD]
[TD] [/TD]
[TD]Dawn[/TD]
[/TR]
[TR]
[TD]30021.10[/TD]
[TD]ROUND HOT ROLLED 3/4"[/TD]
[TD] [/TD]
[TD]Epicor[/TD]
[/TR]
[TR]
[TD]30021.10 [/TD]
[TD]ROUND 3/4" HOT ROLLED [/TD]
[TD] [/TD]
[TD]Dawn[/TD]
[/TR]
[TR]
[TD]30021.11[/TD]
[TD]ROUND HOT ROLLED 7/8"[/TD]
[TD] [/TD]
[TD]Epicor[/TD]
[/TR]
[TR]
[TD]30021.11 [/TD]
[TD]ROUND HOT ROLLED 7/8" [/TD]
[TD] [/TD]
[TD]Dawn[/TD]
[/TR]
[TR]
[TD]30021.13[/TD]
[TD]ROUND HOT ROLLED 1"[/TD]
[TD] [/TD]
[TD]Epicor[/TD]
[/TR]
[TR]
[TD]30021.13 [/TD]
[TD]ROUND 1" HOT ROLLED [/TD]
[TD] [/TD]
[TD]Dawn[/TD]
[/TR]
[TR]
[TD]30021.15[/TD]
[TD]ROUND HOT ROLLED 1-1/8"[/TD]
[TD] [/TD]
[TD]Epicor[/TD]
[/TR]
[TR]
[TD]30021.15 [/TD]
[TD]ROUND 1-1/8" HOT ROLLED [/TD]
[TD] [/TD]
[TD]Dawn[/TD]
[/TR]
[TR]
[TD]30021.16[/TD]
[TD]ROUND HOT ROLLED 1-1/4"[/TD]
[TD] [/TD]
[TD]Epicor[/TD]
[/TR]
[TR]
[TD]30021.16 [/TD]
[TD]ROUND 1-1/4" HOT ROLLED [/TD]
[TD] [/TD]
[TD]Dawn[/TD]
[/TR]
[TR]
[TD]30021.17[/TD]
[TD]ROUND HOT ROLLED 1-3/8"[/TD]
[TD] [/TD]
[TD]Epicor[/TD]
[/TR]
[TR]
[TD]30021.17 [/TD]
[TD]ROUND 1-3/8" HOT ROLLED [/TD]
[TD] [/TD]
[TD]Dawn[/TD]
[/TR]
[TR]
[TD]30021.18[/TD]
[TD]ROUND HOT ROLLED 1-1/2"[/TD]
[TD] [/TD]
[TD]Epicor[/TD]
[/TR]
[TR]
[TD]30021.18 [/TD]
[TD]ROUND 1-1/2" HOT ROLLED [/TD]
[TD] [/TD]
[TD]Dawn[/TD]
[/TR]
</tbody>[/TABLE]

 

[sheetspread]

Ok it still works:

Excel 2010
	A	B	C	D
1	Part	Description	Match?	Source
2	30021.02	ROUND HOT ROLLED 1/4"	TRUE	Epicor
3	30021.02	ROUND HOT ROLLED 1/4"	TRUE	Dawn
4	30021.06	ROUND HOT ROLLED 1/2"	TRUE	Epicor
5	30021.06	ROUND HOT ROLLED 1/2"	TRUE	Dawn
6	30021.1	ROUND HOT ROLLED 3/4"	FALSE	Epicor
7	30021.1	ROUND 3/4" HOT ROLLED	FALSE	Dawn
8	30021.11	ROUND HOT ROLLED 7/8"	TRUE	Epicor
9	30021.11	ROUND HOT ROLLED 7/8"	TRUE	Dawn
10	30021.13	ROUND HOT ROLLED 1"	FALSE	Epicor
11	30021.13	ROUND 1" HOT ROLLED	FALSE	Dawn
12	30021.15	ROUND HOT ROLLED 1-1/8"	FALSE	Epicor
13	30021.15	ROUND 1-1/8" HOT ROLLED	FALSE	Dawn
14	30021.16	ROUND HOT ROLLED 1-1/4"	FALSE	Epicor
15	30021.16	ROUND 1-1/4" HOT ROLLED	FALSE	Dawn
16	30021.17	ROUND HOT ROLLED 1-3/8"	FALSE	Epicor
17	30021.17	ROUND 1-3/8" HOT ROLLED	FALSE	Dawn
18	30021.18	ROUND HOT ROLLED 1-1/2"	FALSE	Epicor
19	30021.18	ROUND 1-1/2" HOT ROLLED	FALSE	Dawn
Sheet4

Cell Formulas
Range	Formula
C2	=B2=IFERROR(VLOOKUP(A2,$A$1:$B1,2,0),"")&IFERROR(VLOOKUP(A2,$A3:$B19,2,0),"")

 

[csimpson24]

Works like a charm! Thank you very much for your help and for your time!