Hello

I have a problem to understand how i need to do/create a formula.

So, for example I have two column, with ranges

A1:A100 - contain only numbers from 1 to 100

B1:B100 - contain any text data

Now i need to get all data from B1:B100 to list, where A1:A100>=20 AND A1:A100<=50

How I can do that ? whic what functions ?

I have i little example what work fine but.. it have only one condition : IF(A1:A100>=20; B1:B100) (i put this formula in Data>Validity>Range Cell) and it's work fine ! but i need TWO conditions.. so my idea it's like a BETWEEN searching..

I hope you understand what i say and my logic.