Show a list of plants requiring a minimum temperature

[Pecoflyer]

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

[silverman166]

Thanks for your explanations, but it still does not work.


Sorry, it seems I omitted to attach the sheet showing my problem in my last post, in which the selected value was not<5, but just 5.


Here it is.


What is going wrong for me?!!


Sounds like I'm also going to have to look into Pivot tables - thanks for the link, and your patience in this problem.