• Hot Topics

Excel Extract a List of Values Filtered by Criteria with Sub-Arrays Tutorial Help

Hi all. I'm looking to create a formula which will let me pick out rows which contain certain parameters (in various columns). This tutorial proceeds to explain this, but only allows for one search parameter; I'd like multiple parameters. Extract a List of Values Filtered by Criteria with Sub-Arrays in Excel Using the template given, I've modified the code to include an AND statement nested in the IF, theoretically solving my issue. But it doesn't work. All that is output is the very first row of the database, whether it fulfills the requirements or not. My data structure is identical to the one given in the tutorial. Here is my modified formula: Code: =IFERROR( INDEX('Car Data'!B$2:B$1156, SMALL( IF( AND( 'Car Data'!$H$2:$H$1156>='Filtered List'!$A$2, 'Car Data'!$E$2:$E$1156='Filtered List'!$B$2 ), ROW('Car Data'!B$2:B$1156)-ROW('Car Data'!B$2)+1 ), ROWS('Car Data'!B$2:'Car Data'!B2) ) ) ,"")

This question generated 69 answers. To proceed to the answers, click here.

This thread is current as of March 28, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel