Display Data by Criteria has multiple rows of data

**harleypop** · 03-10-2009, 12:49 PM

Need help in displaying data by user input criteria, mulitple rows of display also need to display to blank out when no criteria is input. In example spreadsheet the criteria cell is B6 in "Results" page and needs to pull in data from the "Database" page. Thanks

**JBeaucaire** · 03-10-2009, 01:14 PM

Put this formula in E6 and copy it down:

=INDEX(Database!D:D,MATCH(Results!$B$6,Database!B:B,0)+ROW()-6)

**harleypop** · 03-10-2009, 02:56 PM

Originally Posted by JBeaucaire

Put this formula in E6 and copy it down:

=INDEX(Database!D:D,MATCH(Results!$B$6,Database!B:B,0)+ROW()-6)

Thank you this works great, is there a way I can surpress the "0" display when no data is available? Some of the data is larger than others so I have to keep the results box at the larger size.