1. The IFERROR was added to avoid errors when while pulling down, there are no more results satisfying your requirements
2 Your original file has a value of "<5" in D3. This is a text string and will not work as such when comparing to numbers from col B. So you have to replace it with a single value, not using a text string

3 The Pivot Table was another example I provided for a possible solution. Although it is not necessary for a small table, it would be helpful for larger tables.

4. The solution provided is an array formula. They tend to slow down sheets with large ranges and most are nowadays replaced with built-in functions in newer XL versions like O365

Attached Files

Copy of Plants_1.xlsx (10.2 KB, 9 views)