Sumproduct, three formulas ,or if loop?

=SUMPRODUCT(--(B74=BackOrder.csv!$B:$B),--(D74=BackOrder.csv!$D:$D))

I am working on this formula, I've tweaked it a little from the help people gave me here. Here is what I am looking to do. Attached are the two books.

Book BackOrder.cvs is where Book JobsList.xlsx references to verify that data will not be duplicated. What I am seeing is that where there are blank fields I see the number 1048559, i on line 75 instead of 0. And in turn the word "SAME" shows up next to it. Which is technically correct, but it is not correct for the purpose of this sheet.

Is there a way to make it so that if 1048559 shows up it will show "" on "N"? Now on N I am using a simple script:

=IF(M75,"SAME","")


Can someone help me here?

I will be able to explain better if need be, just trying to throw everything together.

Hi

I received this, when i try to download your attachement..

..Invalid Attachment specified. If you followed a valid link, please notify the administrator...

Give this a try:
=IF(OR(B74="",D74=""),"",SUMPRODUCT(--(B74=BackOrder.csv!$B:$B),--(D74=BackOrder.csv!$E:$E)))

Originally Posted by tigeravatar

Give this a try:
=IF(OR(B74="",D74=""),"",SUMPRODUCT(--(B74=BackOrder.csv!$B:$B),--(D74=BackOrder.csv!$E:$E)))

I get an error, #VALUE! on row 75, and duplicates are no longer showing as 'SAME', which rows 5 - 13 should be.