## Saturday, July 13, 2013

### yogi_Making an ArrayFormula Work For Filtering A List Which Is Based On Filtering Another List

Google Spreadsheet   Post  #1281
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul 13, 2013
user; post by danielkupfer; question by Sebastien Marchal (http://productforums.google.com/forum/?zx=oposogcnls8p#!mydiscussions/docs/v53Z9VrvL_M)
How to make a filter formula work with arrayformula 2?
Hi there,

Essentially, what I'm trying to achieve is the same as asked by vivekraj http://groups.google.com/a/googleproductforums.com/d/msg/docs/1hKQ6fnbC-w/LcYFluxNIiQJ (I've tried to ask in that thread but couldn't find out how, believe it or not).

Ahab start answering but in the end there isn't an alternative suggestion on how to combine an arrayformula with a filter formula.

Any help will be much appreciated.

question back on 2010-07-22 by rajvivek (https://productforums.google.com/forum/#!msg/docs/1hKQ6fnbC-w/LcYFluxNIiQJ)
How to make a filter formula work with arrayformula?
I want to insert an arrayformula in the following filter formula so that i can save myself from dragging (dragging a formula across a column or row not only takes time but also change the formatting of the corresponding cells).

=Filter('C I L S'!C\$2:C, 'C I L S'!B\$2:B=D3)

*C I L S is the name of another sheet in the same spreadsheet

I have tried this but it didn't work:
=ArrayFormula(Filter('C I L S'!C\$2:C, 'C I L S'!B\$2:B=D3:d))

Thanks for your help!

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