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

user yachadhoo said: (!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.  


I noticed that if I just took the last part:

That I get an error (in Q3):

What on earth?
This Match is within a 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