Compare 1 column where column B matches

csimpson24

New Member
Joined
Feb 22, 2018
Messages
22
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
 
Last edited:
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
ABC
1NumberDescriptionMatch?
230021.02ROUND HOT ROLLED 1/4"TRUE
330021.02ROUND HOT ROLLED 1/4"TRUE
Sheet4
Cell Formulas
RangeFormula
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)
 
Last edited:
Upvote 0

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
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),"")
 
Upvote 0
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.
 
Upvote 0
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]
 
Upvote 0
Ok it still works:


Excel 2010
ABCD
1PartDescriptionMatch?Source
230021.02ROUND HOT ROLLED 1/4"TRUEEpicor
330021.02ROUND HOT ROLLED 1/4"TRUEDawn
430021.06ROUND HOT ROLLED 1/2"TRUEEpicor
530021.06ROUND HOT ROLLED 1/2"TRUEDawn
630021.1ROUND HOT ROLLED 3/4"FALSEEpicor
730021.1ROUND 3/4" HOT ROLLEDFALSEDawn
830021.11ROUND HOT ROLLED 7/8"TRUEEpicor
930021.11ROUND HOT ROLLED 7/8"TRUEDawn
1030021.13ROUND HOT ROLLED 1"FALSEEpicor
1130021.13ROUND 1" HOT ROLLEDFALSEDawn
1230021.15ROUND HOT ROLLED 1-1/8"FALSEEpicor
1330021.15ROUND 1-1/8" HOT ROLLEDFALSEDawn
1430021.16ROUND HOT ROLLED 1-1/4"FALSEEpicor
1530021.16ROUND 1-1/4" HOT ROLLEDFALSEDawn
1630021.17ROUND HOT ROLLED 1-3/8"FALSEEpicor
1730021.17ROUND 1-3/8" HOT ROLLEDFALSEDawn
1830021.18ROUND HOT ROLLED 1-1/2"FALSEEpicor
1930021.18ROUND 1-1/2" HOT ROLLEDFALSEDawn
Sheet4
Cell Formulas
RangeFormula
C2=B2=IFERROR(VLOOKUP(A2,$A$1:$B1,2,0),"")&IFERROR(VLOOKUP(A2,$A3:$B19,2,0),"")
 
Upvote 0

Forum statistics

Threads
1,223,098
Messages
6,170,099
Members
452,301
Latest member
QualityAssurance

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top