Find duplicates in two columns in two different tables

[flyer8374]

Hello everyone,

I have matching data in two different columns in two different tables. The master table (6445 rows) has it under column "Catalog Number." The table that I want to upload new data (191 rows) associated with the rows with the matching number has that data under column "Item #." I need help typing in a formula that will both match the rows, and indicate with a number "1" in a different column which rows under "Catalog Number" will match up with rows from "Item #."

What the end result of this action is that once I find out which 191 rows from the 6445 row Master Table match up with the other table, I can group all of those matching rows through the sort feature, and delete the rows that don't match. I can then update those rows with new pricing data. I started doing this manually, but I made enough errors where I stopped out of frustration. I hope the sample I've attached will help me to construct a much-needed solution.

I hope that I gave enough information, and thank you in advance for any help that you can provide, because I still have another table that needs to update this master table, but it has 1398 rows compared to the 191 this table has to update for products.

[Estevaoba]

Maybe this in some blank cell in the Pricelist updates tab and copied down:

Please Login or Register  to view this content.

Good luck!

[Gregb11]

I don't know if I fully understand, but would this do it? Put this formula in cell C2 of the Master Pricelist and copy down:

=IF(ISNUMBER(MATCH(A3,'[Pricelist Updates.xlsx]IncrDecr Proposal'!$A$5:$A$20,0)),1,"")

NOTE: you have that column (C) formatted as "TEXT". You should change it back to "General"

[flyer8374]

Will either of the two formulas will return a duplicate result for items on the Master Pricelist that the duplicates on the Pricelist Updates are on different rows? I would also like a way where I can get a value in a new column on the Master Pricelist tab that I can use to separate all the items that return as duplicates where I can use those values to separate the ones that don't return duplicates.

[Gregb11]

Actually, you could just use a COUNTIFS formula and it will show you how many times it shows up on the other file. I.e.:

=COUNTIFS('[Pricelist Updates.xlsx]IncrDecr Proposal'!$A$5:$A$20,A2)