Return multiple rows based on multiple criteria

If you are up for a helper column/s, then you could use this...

=vlookup("*M*",$H$280:$H$352,1,0)
and
=and(H280>0,H280<0.15) you need to decide if you want it to be < 15% or <30%...or just have 2 formulas/columns

Nils88,

Attached is an example workbook based on the criteria you described.
I have hidden rows 3:85 and rows 166:277
In cell M87 is where you can enter a partial match for the values in $H$280:$H$352
In cell D88 is where you can enter the lowest value to find in $I$280:$I$352
In cell D89 is where you can enter the highest value to find in $I$280:$I$352
Row 279 is a header row and data is in rows 280:352
This array formula is in cell C92 and copied down. Note that array formulas must be entered with Ctrl+Shift+Enter and not just Enter:

Please Login or Register  to view this content.

When it runs out of matches, the formula returns a #NUM! error. You had no error checking in your original formula so I did not include any here. Does that work for you?

You're very welcome

If that takes care of your need, please mark this thread as solved.
How to mark a thread Solved
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
Go to the first post
Click edit
Click Go Advanced
Just below the word "Title" you will see a dropdown with the words "No prefix"
Change to "Solved"
Click Save