yogi_Extract Matching Records From Two Sheets Meeting Multiple Criteria Into A Third Sheet

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #726   Sep 02, 2012     www.energyefficientbuild.com.

user yachadhoo said: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/P1YTlLT2U3w)
Return duplicate strings in 2 different filtered arrays in a single formula
Thanks so much, Adam!

It definitely worked for the original example I gave.

I don't understand WHY it works, though...which is probably why I can't apply it to my spreadsheet.  

For:

=FILTER(A:A;B:B=1;MATCH(A:A;FILTER(C:C;D:D=3);0)) 

I noticed that if I just took the last part:

=MATCH(A:A;FILTER(C:C;D:D=3);0)

That I get an error (in Q3):

https://docs.google.com/spreadsheet/ccc?key=0ApQ2E8kH4UvzdDlESkJoV3B6VldfbFRod3ppcEk5Y3c

What on earth?

This Match is within a filter...so how can the filter work, when the match returns an error?

= = =

Secondly, I attempted to apply it to my spreadsheet, and it failed.  :(

I get the same error I was getting with my other feeble attempts, "Mismatched Range Lengths"

OK...Fine...I have shared a copy of my main sheet...with the sheet "HELP" with my failed application of your formula, Adam...

I would greatly appreciate any more help you (or anybody else) is willing to offer.

https://docs.google.com/spreadsheet/ccc?key=0ApQ2E8kH4UvzdFJjN3NaMU5QaW53VXk2S2VGVUVCY3c

Thanks in advance!

--------------------------------------------------------

following is a solution to the problem