Vlookup/Xlookup with 2 conditions

Hello, i been trying to solve an issue with the correlation of two databases that i have, i figured that i used to much time doing manual match for vlookups, so im asking for help on this topic, i have two databases with thousands of data, the correlation between this data bases is one catalog that repeats in x quantity of times, and a code that may repeats a few times, but this is not an issue because the code that repeats belong to the same line, so there is no problem with catalog and code duplicates.
so im looking for a way to vlookup, for a catalog, and if the code is the same for the two databases then write the value, if not go to next value, and if not catalog and code match, n/a# error should appear.

Im adding an example of my data bases.

Best regards.

Why is the wrong formula?

If you want the sum of the pieces per catalog and code indicated it works but I didn't think you wanted this or not ?

Sheet3

c2=SUMIFS(Sheet1!$D$2:$D$4490,Sheet1!$A$2:$A$4490,Sheet3!$A2,Sheet1!$B$2:$B$4490,Sheet3!$B2)

copy down

Thanks, but i dont need the sum i need the correlation, if the catalog is 1 and the code is A
but i also have the catalog 1 but with code B, i need what pieces apply for catalog 1 with code A and the same por same catalog 1 but code B, if i have two catalogs with same code: example catalog 1 code b, catalog 1 code b, i dont have any problem with that, just make the diferentiation with the codes.

sOLVED MY PROBLEM USING XLOOKUP, INDEX MATCH, SUMIF. ALL SEPARATE SOLUTIONS.