Sunday, September 2, 2012

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):

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.

Thanks in advance!
--------------------------------------------------------

following is a solution to the problem