Update new coklumn basis on linked between existing column

[Tid14]

I am working on alteryx workflow where in excel file have data as:
Material No. Part Number Now
null                    712
null                   712
null                   712
405                  712
405                  712
395                  672
null                  672
null                  null
null                  null
null                  null
100                 null
100                null

Now from the above data, I want in my output that if i know that the rows in which
,material number and part number is linked are correct and for eg-
If in any case material number and part number are linked (405 and 712 or 395 and 672)
so in the case where material number is null and part number is something which is already linked in the data
then in new column I want "DC but cataloged"
written indicating that we have material number for this.
And for other examples like where material number and part number both are null or where material number is 100
and part number null then in those cases New column output for those rows should be null only.
How can we do this in Alteryx?

[KGT]

This could be solved in one formula except for the part that matches the existing material Numbers. In the attached, I've laid out the steps. You can use  a test to make sure you get all the records back.... I've shown that as well, but it's only needed if you want.

There are many ways to achieve this task, and so I went with a way that is easily explainable and you can add/adjust easily.